Answer Posted / nish

there are plenty of options available.
just carefully study the scenario.

Source: 4 Mil records (doesn't change)
Target: 3 Million already loaded
Option1:
you just need to identify those 1Million pool them and then load to target.

This is clearly a case for Change Data Capture (CDC) stage.
use the Source As Before Table and Target as After.
Write those 1 Mil records based on change_code() (Deleted) to a file.
Move the contents of this file to target.

Option 2: This scenario also hints at updating the target with merge stage.use the DROP option to gather into a file and then update the target.

Option 3: Look Up being a performance concern should be your alternative.

What is data partitioning?

1268

---

AGGREGATOR default datatype

1523

---

How do you run datastage job from the command line?

1129

---

What is the difference between validated and compiled in the datastage?

1372

---

What are the components of ascential data stage?

1241

---

What is the roundrobin collector?

1150

---

Differentiate between datastage and datastage tx?

1112

---

Where the datastage stored his repository?

1140

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330

---

What are the areas of application?

1197

---

How do you schedule or monitoring the job?

1267

---

What is the difference between hashfile and sequential file?

1318

---

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?

2263

---

What is active and passive stage?

1467

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2928

---