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

Define oconv () and iconv () functions in datastage?

1369

---

how to write server Routine coding?

2082

---

Can you explain kafka connector?

1263

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1024

---

what are the errors,warnings in datastage

2642

---

What is apt_config in datastage?

1098

---

How many types of sorting methods are available in datastage?

1033

---

Difference between in process and inter process?

1186

---

Name the third party tools that can be used in datastage?

1038

---

What is datastage engine?

1140

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2208

---

How can you write parallel routines in datastage PX?

991

---

Name the command line functions to import and export the DS jobs?

1111

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1705

---

What is the difference between account and directory options ?

1131

---