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
- 7227 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / upputuri.vinod
first of all we have to split the value into individual char
value(1,1) v(2,2) v(3,3)
c1 c2 c1 c2 c3 c4
1 AB 1 A B
2 ABC---> 2 A B c----> pivot--->o/p
3 ADE 3 A D E
4 A 4 A
| Is This Answer Correct ? | 2 Yes | 4 No |
How complex jobs are implemented in datstage to improve performance?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
When we will go for Data elements?
How to read multiple files using a single datastage job if files have the same metadata?
What are the environmental settings for data stage,while working on parellel jobs?
Where do you see different stages in the designer?
What is Cleanup Resources and when do you use it?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
How to RD using transformer?
How To find the location of APT_confid file
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
Teradata 
