Transformer stage scenario based questions.

 

Question: Design a data stage job to get a target output as below .

Source:         Target 

Eno Ename    Eno Ename 

1      a,b           1      a 

2      c,d            2     b

 3      e,f           3      c

 

Design : 

 

sequence  stage -> transformer ->row generator ->target 

 

Transformer – Split the Ename Column

Create two new columns:

ename1 = Field(Ename, ",", 1)

ename2 = Field(Ename, ",", 2)

Row Generator Stage

Purpose: Convert columns → rows

Row Generator Properties

·        Number of rows to generate: 2

·        Row number column: row_num

Transformer – Output Logic

o   Derive Ename:

§  If row_num = 1 Then ename1

§  Else ename2

§  Derive Eno using Sequential Counter:

o   NextValue()

§  ✔️ This produces:

§  a

§  b

§  c

·        Final Output Produced

Eno	Ename
1	a
2	b
3	c