I need to validate data where source is Oracle database('A'), data is extracted and transformed to a view in Oracle database('B') to best fit target data structure and finally ETL from view 'B' to target Salesforce('C'). Source table has about 90 tables but target has about 38 tables so lot of data is being transformed.
How can I best validate the data quality from either C to A or B to A knowing source is Oracle and target is Salesforce or, is there any best way to even reverse engineer the view 'B' to form a new table 'D' mimicking source table 'A' so I can direct compare 'A' to 'D' like apples to apples.
Any suggestions will be greatly appreciated. I am open to any idea or best practice to validate data between Salesforce and Oracle.
Thank you