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.

Enlist various types of routines in datastage.

1244

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2368

---

Define Data Stage?

1087

---

what is the use of materialized view?

1561

---

What are the processing stages?

1095

---

What is active and passive stage?

1407

---

Which warehouse using in your datawarehouse

2182

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2718

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2275

---

EXPLAIN SCD

1389

---

Define Job control?

1137

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2891

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2454

---

How you can fix the truncated data error in datastage?

1774

---

Explain ibm infosphere information server and highlight its main features?

1084

---