Answer Posted / shailesh

simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target

in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output

What is use Array size in datastage

1300

---

what is repositery?

1293

---

Explain connectivity between datastage with datasources?

593

---

How to manage date conversion in Datastage?

638

---

What are the some differences between 7.x and 8.x version of datastage?

737

---

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1649

---

Terminate Activity

837

---

Name the different types of Lookups in Datastage?

727

---

Does datastage support slowly changing dimensions ?

659

---

What are some prerequisites for datastage?

615

---

options available in sequence job to run,validate?

832

---

Can you explain engine tier in information server?

650

---

how can we create rank using datastage?what is the meaning of rank?

8159

---

What is the difference between an operational datastage and a data warehouse?

628

---

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

770

---