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 the difference between hashfile and sequential file?

1270

---

how many rows sorted in sort stage by default in server jobs

4005

---

What is the process of killing a job in datastage?

1026

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

939

---

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

1103

---

What are the types of views in datastage director?

1779

---

How can we improve performance of data stage jobs?

1026

---

What is the difference between an operational datastage and a data warehouse?

1162

---

Where do the datastage jobs get stored?

1224

---

Can you explain link buffering?

1188

---

Nls stands for what in datastage?

1199

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2637

---

What are datastage sequences?

1131

---

Enlist various types of routines in datastage.

1263

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2979

---