Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7345 Views
- IBM, I also Faced
- E-Mail Answers
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
what are the errors,warnings in datastage
What are sequencers?
What are the steps required to kill the job in Datastage?
Why fact table is in normal form?
What is data partitioning?
Can you filter data in hashed file?
What are the components of datastage?
What are the types of jobs we have in datastage?
What are some prerequisites for datastage?
What is the difference between the local container and shared container?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Explain connectivity between datastage with datasources?
Different ways a project can be moved to production ?...example ….export-import and Version control.
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?
sed,awk,head
