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

How many Key we can define in remove duplicate stage?

1310

---

What is difference between join, merge and lookup stage?

1039

---

Explain ibm infosphere information server and highlight its main features?

1034

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1473

---

Explain usage analysis in datastage?

1095

---

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

999

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1029

---

Name the different types of Lookups in Datastage?

1214

---

How do you import and export data into datastage?

1166

---

What are the components of ascential data stage?

1110

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3264

---

What are sequencers?

1057

---

How many types of hash files are there?

1117

---

How you can fix the truncated data error in datastage?

1674

---

What is the difference between datastage and informatica?

1059

---