Answer Posted / prashant jaiswal

To explain with example, If you have 10 records with dedupe
key having values of 10,10,20,30,30,30,30,40,40,50. On
deduping UNIQUE, you will get 20 & 50 in your output.
Remaning records comes out in the dup port.

What are the operations that support avoiding duplicate record?

1490

---

What is the difference between a scan component and a rollup component?

1233

---

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1146

---

How co>operating system integrates with legacy codes?

1245

---

How you can run a graph infinitely in ab initio?

1651

---

What is sandbox?

1254

---

Mention what is the syntax for m_dump in abinitio?

1519

---

What are the key elements of a data processing system?

1306

---

Explain PDL with an example?

1368

---

What is the difference between partitioning with key / hash and round robin?

1476

---

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1183

---

Difference between output_index and output_indexes in reformat

1350

---

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1137

---

What is air-project parameter ?

2268

---

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1129

---