Hi,
I am trying to compare if the data in one column is same in two different tables in different databases, how do you think I should go about this in QualityStage , please advice.
New to QualityStage , lot of questions
New to QualityStage , lot of questions
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not use a simple DataStage job?
How do you identify the rows that you want to compare?
Or is the question that you want to compare domains? (That is, the set of values in a column in Table A versus the set of values in a column in Table B. Information Analyzer can do that.)
What's specific about QualityStage that makes you want to use that?
How do you identify the rows that you want to compare?
Or is the question that you want to compare domains? (That is, the set of values in a column in Table A versus the set of values in a column in Table B. Information Analyzer can do that.)
What's specific about QualityStage that makes you want to use that?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I actually want to do the set of values in a column in Table A versus the set of values in a column ... somebody put it in my head that I can do it using reference stage in QualityStage.. that is why I am after it.. have never used QS or Information Analyze before..ray.wurlod wrote:Why not use a simple DataStage job?
How do you identify the rows that you want to compare?
Or is the question that you want to compare domains? (That is, the set of values in a column in Table A versus the set of values in a column in Table B. Information Analyzer can do that.)
What's specific about QualityStage that makes you want to use that?
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne