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
- 7338 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 some prerequisites for datastage?
table actions available in oracle connector?
What is the method of removing duplicates, without the remove duplicate stage?
What is the difference between in process and inter process?
root tree will find which is server job and which is parallel job?
What is ibm datastage flow designer?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How a source file is populated?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are constraints and derivations?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the purpose of interprocessor stage in server jobs?
sed,awk,head
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the purpose of pivot stage?
