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 do you remove duplicate values in datastage?
What a datastage macro?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
If you want to use a same piece of code in different jobs, how will you achieve this?
How to perform incremental load in datastage?
What are the types of containers?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How do you reject records in a transformer?
What is data partitioning?
How do you run datastage job from the command line?
Difference between in process and inter process?
How do u convert the columns to rows in datastage?
What is orabulk stage?
What is the difference between operational data stage (ods) and data warehouse?
What is ibm datastage flow designer?