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...

Can you explain tagbatch restructure operator?

1168

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1209

---

How many types of sorting methods are available in datastage?

1067

---

what are the errors,warnings in datastage

2691

---

What is aggtorec restructure operator?

1434

---

client know skid info?

2078

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2100

---

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

1017

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

917

---

Can you explain link buffering?

1174

---

how to sort two columns in single job in datastage.

2895

---

Define Merge?

1313

---

How can we improve performance of data stage jobs?

1012

---

Describe the main features of datastage?

1072

---

What are the types of containers and how to create them?

974

---