I/P
---
ID Value
1 AB
2 ABC
3 ADE
4 A
O/p
---
ID Value
1 A
1 B
2 A
2 B
2 C
3 A
3 D
3 E
4 A
Answer Posted / subbuchamala
SRC-->TFM--->TGT
in TFM, Use Stage variables and Loop variables as below:
StageVar-->Len(Lnk.Value)===>this will give length of string of "Value" column. i.e.,
ID Value StageVar
1 AB 2
2 ABC 3
3 ADE 3
4 A 1
Next, in the Loop variable part:
Loop While==> @ITERATION<= StageVar
For each input row, Loop will repeat until "Value" length finishes.
Add new Loop variable-->LoopVar and put below derivation:
Left(lnkCstIPSGMSPread.IJABL, @ITERATION)-->LoopVar
Next, in the Output Col Derivation:
Lnk.ID-->ID
LoopVar-->Value
Finally, you will required Output.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to read the length of word in unix?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the some differences between 7.x and 8.x version of datastage?
What is the project in datastage?
Define data aggregation?
How to perform incremental load in datastage?
How and where you used hash file?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is datastage?
project Steps,hits, Project level HArd things,Solved methods?
how to write server Routine coding?
How to implement complex jobs in data stage?
Define orabulk and bcp stages?
What is the use of datastage designer?
What are some different alternative commands associated with "dsjob"?