DataStages_Real_Time _Scenarios_ with Screen Shots_and _Solution

Tuesday, June 3, 2014

@ 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




2 comments:

  1. hi r u giving online training on datastage If so please share me your number so that I can spk with u regarding dis. Thank you.

    ReplyDelete
  2. I have source
    id
    1
    2
    3
    i need output as
    id
    1
    2 2
    3 3 3
    please help me

    ReplyDelete