Answer Posted / amit

using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.

This will remove duplicate in transformer stage.

What are the various kinds of the hash file?

1151

---

What is the command line function to import and export the ds jobs?

1153

---

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

1089

---

Differentiate between data file and descriptor file?

1060

---

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

1030

---

Differentiate between datastage and datastage tx?

1051

---

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

1063

---

What are routines in datastage?

1329

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

Lookup constraints

1257

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

How to convert RGB Value to Hexadecimal values in datastage?

3998

---

What are the types of containers in datastage?

1191

---

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

1027

---

What is a merge?

1169

---