Help required in Transformer stage 8.7

kpavan2004 · Post by **kpavan2004** » Mon Jun 17, 2013 7:17 am

Hi All ,

I am using DS 8.7 Enterprise Edition. My Job design for delta processing is as below

Seq File --> Join (Reference link is TD Connector Stage) --> Transformer --> Split as per rules like Insert/Update/Close --> Combine and send to target.

I am seeing strange behaviour that when i change the link ordering in the Stage properties of the transformer i am getting different number of records. It is much appreciated if anyone tells us what should be link ordering.

crystal_pup · Post by **crystal_pup** » Mon Jun 17, 2013 8:57 am

You cannot have multiple input links in a transformer stage - so only one input link will always appear in the link ordering tab of the transformer stage properties page.

Kindly confirm if you have changed the link ordering in the Join stage.
The link ordering (that specifies which input link will act as a left table/right table) is very important in a Join stage to get desired output.

jwiles · Post by **jwiles** » Mon Jun 17, 2013 8:57 am

In a transformer stage, link ordering simply describes the order in which the output links (constraints and derivations) are processed.

If you are using the "otherwise" constraint option for only one of the output links (to capture any records that did not get written to any other links), make sure that link is the last in the order.

Regards,