compare two records in DataStage
Posted: Thu Feb 14, 2013 1:37 am
Hi All,
Is it possible to compare two records in DataStage, then decide what value to add to a new field on each record?
For example, if Record 1 has an 'A' and Record 2 has a 'B' then, add a new field with 'Z' for Record 1 and 'Y' for Record 2. But, if Record 1 has an 'A' and Record 2 has a 'C', the new values would be different. Hopefully that makes a little sense
Any idea please share...
Is it possible to compare two records in DataStage, then decide what value to add to a new field on each record?
For example, if Record 1 has an 'A' and Record 2 has a 'B' then, add a new field with 'Z' for Record 1 and 'Y' for Record 2. But, if Record 1 has an 'A' and Record 2 has a 'C', the new values would be different. Hopefully that makes a little sense
Any idea please share...