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
.... Any clues on this please