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
- 7467 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 can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
what is snow flack schema?
How to transfer file from one system to another system in UNIX?which command to be use?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
What are the difference types of stages?
what is executable in DataStage?
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
what is mapping lookup
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
what is diff b/w datastage 8.1,8.5,8.7?
ename like ibm,tcs,hcl need display those records only how?
Teradata 
