Page 1 of 1

Processing record using their SID's

Posted: Thu Mar 08, 2007 1:20 pm
by sylvan_rydes
Hi All,

This is something I couldn't figure out myself and here I am asking you. I need to process records from source in a certain way.

I have two keys. First one is primary and other one is secondary. Now based on these two values, these records go through different transofrmation. And my concern is only to keep track of these two keys. Like if K1 is X and K2 is Y then only fetch the next record otherwise keep processing the first record.

I know I can do it using Job Sequencer but how can I do it in same job. All help will be appreciated.

Sylvan

Posted: Thu Mar 08, 2007 2:10 pm
by DSguru2B
You completely lost me. Can we get some more explanation with data?

Re: Processing record using their SID's

Posted: Thu Mar 08, 2007 2:22 pm
by gateleys
We could do with some sample input data, and how you would like it at the output.

gateleys

Posted: Thu Mar 08, 2007 3:09 pm
by ray.wurlod
Two output streams from the transformer - one taken if the lookup succeeds, the other taken if the lookup does not succeed.

Or more output streams, different ones taken for different returned values from the lookup, and coded into the constraint expressions.