Compare stage

[Ragunathan Gunasekaran]

Hi,
I am trying to understand the compare stage in datastage . The manual states that by comparing the key columns(Columns on which the change has to be detected) from the input datasets the result codes are output.

Say i have a key column "col_a" in both the input datasets.
Hence

Code: Select all

if First.Col_a <second.col_a result code should be -2
if First.Col_a >second.col_a result code should be 2

If i have a two key columns then how this result code is achieved ?
.... Any clues on this please

[ray.wurlod]

A buffer comprising all the columns defined as "Key" is the basis of comparison.

[Ragunathan Gunasekaran]

I hope that the answer would be Depending of the order of the keys defined in the stage.
The key defined at the top of the declaration would be used first for a match and the second key is used for comparison. If the second key is less or greater depending upon that the comparison result is recorded in the output