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
- 7462 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 is data partitioning?
Why we use surrogate key?
What is the difference between odbc and drs stage?
Why fact table is in normal form?
What are the repository tables in datastage?
What are the components of datastage?
Can you explain tagbatch restructure operator?
Difference between data warehousing and olap?
What are sequencers?
What are the various kinds of the hash file?
how do u catch bad rows from OCI stage? And what CLI stands for?
Different ways a project can be moved to production ?...example ….export-import and Version control.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Explain entity, attribute and relationship in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
