Answer Posted / datastage4you

Whenever there is any header and footer with file, those must identifiable like First line will be header or last line will be footer or by some column info (row type)

so if data follows first criteria, use unix or datastage head and tail to extract those

thanks
www.datagenx.net

What is the method of removing duplicates, without the remove duplicate stage?

1079

---

How many types of sorting methods are available in datastage?

1114

---

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

1430

---

how to implement scd2 in datastage 7.5 with lookup stage

5663

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1133

---

EXPLAIN SCD

1450

---

Can we use target hash file as a lookup ?

3372

---

What are the different plug-ins stages used in your projects?

1125

---

What are the different kinds of views available in a datastage director?

1075

---

CHANGE CAPTURE

1352

---

Distinguish between informatica & datastage. Which one would you choose and why?

1043

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1208

---

Triggers,VIEW,Procedures

1265

---

whom do you report?

1984

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1349

---