Answer Posted / subhash

1. SRC---->TFM---->PIVOT Stage---->TGT
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
COL1 COL2
C1 1
C2 2
C3 3
c4 4
c4 5
c5 6
c6 7
C7 8

in TFM,
put below condition for Col2 derivation.
If COL2<4 AND COL2>0 then 1 elseIf COL@>3 AND COL2<7 then 2 else 3
then out from tranformer looks like this
COL1 COL2
C1 1
C2 1
C3 1
c4 2
c4 2
c5 2
c6 3
C7 3
then do the Vertical PIVOT on
GROUP BY COL2,
PIVOT COL1
then u will get below output:
Col2 COL1_1 COL1_2 COL1_3

1 c1 c2 c3
2 c4 c4 c5
3 c6 c7
we can drop COL2 in TGT

EXPLAIN SCD

1404

---

Differentiate between datastage and datastage tx?

1051

---

What is the difference between hashfile and sequential file?

1260

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

---

Can you implement SCD2 using join, transformer and funnel stage?

1557

---

Why do you need stage variables?

1180

---

Notification Activity

1400

---

why do u need the IOS upgradation in a FC switch

2282

---

how to add a new records into source?

2000

---

Differentiate between datastage and informatica?

1181

---

What is datastage engine?

1179

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2446

---

Define ds designer?

1278

---

What is difference between server jobs & parallel jobs?

1038

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

---