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

whom do you report?

1923

---

How to implement complex jobs in data stage?

1108

---

Explain how a source file is populated?

1362

---

What are the repository tables in datastage?

1301

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2439

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2227

---

What are the various kinds of containers available in datastage?

1046

---

What are the components of datastage?

1121

---

What are the types of jobs we have in datastage?

1071

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

---

how to export or import the jobs in .ISX file

1197

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

---

What steps should be taken to improve Datastage jobs?

1065

---

Define Data Stage?

1087

---

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

1375

---