Display the Lookup Value

[ray.wurlod]

While DataStage does not "display" anything (it runs as background processes), what you are describing is precisely how the lookup mechanism in the Transformer stage works. Supply the reference key expression with the input value. On the other end of the reference input link have a stage type that accesses Oracle, and specifies just those two columns from the Oracle table, marking one as the key. If the lookup succeeds, then values are returned for both columns; if the lookup fails, then NULL is returned for each column on the reference input link. You can use this information to decide what to do with the input row. If the Oracle table is on a different machine than the DataStage server, consider loading the two columns into a local table or hashed file, for performance reasons.

[kksr]

Thanks Ray.