in datastage interview qustion
source target
------- -------
12345 1
2
3
4
5
Answer Posted / subbuchamala
SRC-->TFM--->TGT
in TFM, Use Stage variables and Loop variables as below:
StageVar-->Len(Lnk.Source)===>this will give length of string of "Source" column. i.e.,
Source StageVar
12345 5
Next, in the Loop variable part:
Loop While==> @ITERATION<= StageVar
For input row, Loop will repeat until "Source" length(5) finishes.
Add new Loop variable-->LoopVar and put below derivation:
Left(Lnk.Source, @ITERATION)-->LoopVar
Next, in the Output Col Derivation:
LoopVar-->Target
Ex:
For 1st ITERATION: Left("12345", 1)==>1
For 2nd ITERATION: Left("12345", 2)==>2
....
....
Finally, you will required Output.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain how a source file is populated?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
what is ds administrator used for?
Differentiate between odbc and drs stage?
What is "fatal error/rdbms code 3996" error?
If you want to use the same piece of code in different jobs, how will you achieve it?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what are the devoleper roles in real time? plz tell i am new to datastage....
what is repositery?
Describe routines in datastage? Enlist various types of routines.
What is ibm datastage flow designer?
What is the difference between the local container and shared container?
What is data partitioning?
What are the steps needed to create a simple basic datastage job?
which r the connectors used in san?