on 10-11-2010 10:25 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.