DSXchange

Hi,

When I must compare two files in Datastage is there a Stage that in output returns the name of the column and the value that is differents ?

Example:

TextA:
C0=0
C1=0
C3=0

TextB:
C0=0
C1=0
C3=1

Result of the compare: C3=1

How can I do this in Datastastage?
Thanks!

IMHO you would be better off sticking to a file comparison utility for something like that, I use UltraCompare for example. For DataStage, you would have to individually compare all fields after joining on record numer in order to find those differences since you want to know what changed rather than simply something changed.