@ ITERATION : Datastage 8.5 Enhacements

Transformer looping has been included in the transformer stage by I.B.M

@ITERATION Used in the looping Machanism

There are two types of looping  available here.

Scenario  with Example:-

I/P

Source File

stdId,Subjects
101,maths/science/English
102,english/social/maths
103,soical/science
104,network/games
105,maggi

Out/put

stdId,Subjects
101,maths
101,science
101,english
102,english
102,social
102,maths
103,social
103.science
104,net work
104,games
105.maggi


please check below snapshots

 here m using two xf-funcctions

Dcount , filed and looping variable

 Expected Results

Thanks & Regards,
Siva