Answer / 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.

Answer / np

Use Pivot stage

Answer / lajpat kurdiya

SELECT SUBSTR(12345,LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH(12345);


SELECT SUBSTR('12345',LEVEL,1) AS Source
FROM DUAL
CONNECT BY LEVEL <= LENGTH('12345');

how to add a new records into source?

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

Explain ibm infosphere information server and highlight its main features?

0 Answers  

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

What are iconv and oconv?

0 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

---

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

---

Differentiate between hash file and sequential file?

0 Answers  

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---