DSXchange

Hi All,

I'm stuck with a scenario wherein I need to provide duplicates of a recod on conditional basis. E.g. In the transformer stage I may check for the type, and let's say if I get the condition type='A', then I need 3 duplicates of the current record. That is, if the input row is:

1,A,20455,"Fault Description"

Then since I find type='A', then I would want exactly three output rows for the same. i.e.,

1,A,20455,"Fault Description"
1,A,20455,"Fault Description"
1,A,20455,"Fault Description"


Is this possible using datastage?

Thanks & Regards,
Sriram Garikapati

Yes. Do the test in stage variables. Have three outputs from the Transformer stage, each constrained by the same expression. Use a Funnel stage downstream to bring them together if that's required.

Hi Sriram,

If you are reading from a sequential file. Read as a complete row into a single column.
in the transformer stage,
After transformer stage convert row into column based on the delimter "-" then use column import stage to split the columns and finally load in to target.

Thanks,
Suresh

If you're coding this in IS 8.5, the transformer loop functionality will handle this quite easily.

Regards,

you can use a filter to check for the condition and put a copy stage with 3 output links to make 3 copies of the filtered record. Then output of copy stage can be collected together using a funnel stage.

Regards
Ulhas