Answer Posted / upputuri.vinod

Bro that's right I have another ans as-well..

I am going to use copy and funnel stages to implement the
pivot functionality.


name ph1 ph2---> copy--->cp1 name ph1
| funnel---->o/p
|____>cp2 name ph2

CP1 and CP2 are the TWO links from COPY..

in cp1 we have the name and ph1 where in cp2 name and ph2.

In funnel stage i am going to club the two links and send it
to o/p.


THE BENEFIT IN THIS IS WE CAN USE PIVOT UPTO 3250 ROWS
ONLY.. AFTER THAT IT WONT WORK..

SO WE CAN USE IT...

Differentiate between validated and Compiled in the Datastage?

1291

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2166

---

how to abort the job its matain duplicates?

2584

---

What is the different type of jobs in datastage?

985

---

Which commands are used to import and export the datastage jobs?

1419

---

What is the process of killing a job in datastage?

1026

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5134

---

How to implement complex jobs in data stage?

1120

---

What is usage analysis in datastage?

1317

---

Define ds designer?

1287

---

How do you import and export the datastage jobs?

1171

---

Describe link sort?

1019

---

Have you have ever worked in unix environment and why it is useful in datastage?

1138

---

How to clean the datastage repository?

1133

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2374

---