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

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5194

---

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

1118

---

Define ds designer?

1328

---

What is ibm datastage?

1025

---

What is the difference between account and directory options ?

1234

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2853

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2491

---

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

1795

---

Why do you need stage variables?

1231

---

How the ipc stage work?

1170

---

What is the difference between orabulk and bcp stages?

1076

---

What is apt_config in datastage?

1197

---

Explain usage analysis in datastage?

1224

---

What is the flow of loading data into fact & dimensional tables?

1113

---

Describe link sort?

1060

---