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');

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

How do you remove duplicate values in datastage?

0 Answers  

---

Differentiate between validated and Compiled in the Datastage?

0 Answers  

---

what are the types of nodes

4 Answers   HCL, TCS,

---

What are sequencers?

0 Answers  

---

how to call routines in stages?

3 Answers   ME,

---

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

---

how can we create tables in datastage?

1 Answers  

---

What is the difference between in process and inter process?

0 Answers  

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

how to validate the jobs

2 Answers   IBM,

---