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

Define oconv () and iconv () functions in datastage?

1341

---

What is a ds designer?

1024

---

What is ibm datastage?

915

---

How to convert RGB Value to Hexadecimal values in datastage?

3927

---

How a routine is called in datastage job?

1043

---

Define project in datastage?

1051

---

How complex jobs are implemented in datstage to improve performance?

962

---

Define Routines and their types?

1096

---

What are transforms and what is the differenece between routines and transforms?

999

---

What is difference between server jobs & parallel jobs?

986

---

How do you reject records in a transformer?

1060

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

---

Can you explain tagbatch restructure operator?

1115

---

What is active and passive stage?

1360

---

What are the benefits of datastage?

1173

---