DSXchange

How do we implement FOR or DO looping in transformer?

First let IBM release the next version of datastage and then you will be able to use looping variables. Till then use workarounds including parallel routines.

Thats what exactly I am looking for.... with which work around I can implement it

How about you first explain to us why you think you need to do "looping" in a transformer? Perhaps there is another way to accomplish whatever it is that you need to do.

I have data like:

ID Flag
1 Y
1 N
1 Y
2 Y
2 Y
2 N
2 N
3 N
3 Y

The output I want is:

ID Flag
1 Y
2 Y
3 Y

That is across each id it would check for flag and if this is 'Y' against any occurence, It would give Y a final output with one occurence of ID.

If I interpret your logic correctly that you want one occurrence of Y's, then use the constraint Flag = 'Y' in Transformer together with either a Sort (no dups) or Dedupe.

Or aggregate by ID and Max(flag)

Or stage variable to detect whether 'Y' has been encountered, and either stage variables or Key Change column from Sort stage to detect change of key.

Trivial in a Server job as well. No looping required.

hmm
Thanks to all.