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.

What is the difference between an operational datastage and a data warehouse?

1092

---

Nls stands for what in datastage?

1145

---

describe the Steps to confiure a Qlogic switch

2330

---

How you Implemented SCD Type 1 & Type 2 in your project?

4075

---

EXPLAIN SCD

1341

---

What are the features of datastage flow designer?

993

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1141

---

Can you explain link buffering?

1111

---

which r the connectors used in san?

2144

---

What is difference between join, merge and lookup stage?

1041

---

What is the difference between datastage and informatica?

1062

---

To see hidden files in LINIX?

1454

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2330

---

How the ipc stage work?

1080

---

what is use of SDR function?

5128

---