cancel
Showing results for 
Search instead for 
Did you mean: 

table_comparison - how to compare data at a high level

Former Member
0 Kudos

Hi,

I have to do data validation at a high level between two tables that I am loading.

I am trying to use table_comparion transform but the problem is that my target table is at a much lower level than at which I want to compare data. So it has many more columns (both key and data fields) than what I want to compare.

Does the output of query transform ( which I am using as input into table_comparion) be in the exact same format as comparion table? If not, then can somebody suggest me something else.

Or how can I compare output of two query transforms ?

Thanks,

Saurabh Bansal

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear Saurabh,

Not sure if you have already got the solution to this. If yes please close the thread.

If not, i would suggest you can use the validation rule to compare the two tables and then based on the PASS or FAIL result can check what needs to be done on the output.

Do post back if you have got the solution or you need any furthur help or else close the question.

regards,

Den