Answer Posted / mohit

We can solve this by using Change capture stage. First,we
use source as 'A' and refrerence as 'B' both of them are
connected to Change capture stage. From, change capture
stage it connected to filter stage and then targets X,Y and
Z.
(Change Code '0'--->exist in both, copy record
Change Code '1'--->Exists in SRC 'A', INSERT record
Change Code '2'--->Exists in SRC 'B', DELETE record
Change Code '3'--->Exists in 'A' & 'B' with changes, UPDATE
record)

In the filter stage:
Change_code column=1 it goes to 'X' [1,2,3,4,5]
Change_code column=0 it goes to 'Y' [6,7,8,9,10]
Change_code column=2 it goes to 'Z' [11,12,13,14,15]

Why do we use exception activity in Datastage?

1288

---

What are some different alternative commands associated with "dsjob"?

1144

---

Explain usage analysis in datastage?

1147

---

Highlight the main features of datastage?

1147

---

Define Job control?

1125

---

What is the purpose of pivot stage and types of containers in datastage

1028

---

Define project in datastage?

1085

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3326

---

What is the command line function to import and export the ds jobs?

1133

---

CHANGE CAPTURE

1293

---

Define Merge?

1298

---

How to manage date conversion in Datastage?

1118

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1214

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1863

---

What is the importance of the exception activity in datastage?

1056

---