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

Lookup constraints

1306

---

whom do you report?

1984

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2266

---

What is a merge in datastage?

1341

---

Can you explain link buffering?

1221

---

why do u need the IOS upgradation in a FC switch

2335

---

What are some prerequisites for datastage?

1168

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1428

---

How many types of sorting methods are available in datastage?

1114

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

---

how to write server Routine coding?

2179

---

How can you write parallel routines in datastage PX?

1065

---

how to implement scd2 in datastage 7.5 with lookup stage

5663

---

What are the main features of datastage?

1350

---

How to clean the datastage repository?

1178

---