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

What are the different type of jobs in datastage?

1082

---

Distinguish between informatica & datastage. Which one would you choose and why?

1043

---

What is the method of removing duplicates, without the remove duplicate stage?

1078

---

Define APT_CONFIG in Datastage?

1135

---

sed,awk,head

1500

---

What is ibm datastage flow designer?

1203

---

Differentiate between operational datastage (ods) and data warehouse?

1231

---

How do you schedule or monitoring the job?

1266

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4237

---

describe the Steps to confiure a Qlogic switch

2437

---

Can you explain link buffering?

1221

---

Name the different sorting methods in datastage.

1098

---

What is the difference between passive stage and active stage?

1642

---

How to perform incremental load in datastage?

1260

---

What are the primary usages of datastage tool?

1128

---