Transformation -- Within Lookup

[dsnk]

Hi,

I have lookup criteria where I have to implement a business transformation on the output filed if the lookup is success. And implement a different logic if the lookup fails.

Normally, we used to have a flag from the Lookup stage. And based on the flag value, we will implement the Transformation logic in the next Stage (usually transformer).

Is there a way to implement the business transformation logic along with the lookup process within a single stage? Or is there a way to implement transformation logic in Lookup/Similar stage?

Please suggest.

Thanks

[ray.wurlod]

In a word, no. The philosophy of parallel job design is one stage, one task. Lookup stages do lookups, Transformer stages do transformation.