Answer Posted / rohit babar

There are 3 ways by which we can remove the duplicate records
1. By using remove duplicate stage. We have control here on which record we want to remove it's first or last. There is option record to retain in remove duplicate stage where we select first or last option.

2. By using sort stage. there is option allow duplicate in sort stage. We set this option true when we want duplicate records & If we want unique records we set it to the false

3. By in-line sorting. In Partition tab of any stage when we select key base partition tech. then perform sort option will enable if we check this option next 2 option will enable which is stable & unique if we select stable that means we allow duplicate records & if we select unique that means we remove duplicate records and getting unique records

Define data aggregation?

1093

---

Can you explain kafka connector?

1306

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2171

---

Define Merge?

1317

---

What are the functionalities of link collector?

1085

---

Why do you need stage variables?

1180

---

What is data partitioning?

1199

---

What are routines in datastage? Enlist various types of routines.

1100

---

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

1377

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1214

---

What is the differentiate between data file and descriptor file?

1359

---

Can you explain tagbatch restructure operator?

1173

---

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

3460

---

what is use of SDR function?

5171

---

What is difference between symmetric multiprocessing and massive parallel processing?

1136

---