DSXchange

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.

Please be more specific about what you mean by "compare". QualityStage may not be the tool of preference.

ray.wurlod wrote:Please be more specific about what you mean by "compare". QualityStage may not be the tool of preference.

Compare as in checking whether the values in columns of both the tables is the same.

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?

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?

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..

select * from
(
select distinct(FieldA) as SetA from TableA
) A
full outer join
(
select distinct(FieldB) as SetB from TableB
) B
on SetA = SetB