Answer Posted / ankit gosain

Hi,

You can achieve the unmatched records from Primary and
Secondary with the help of Full Outer Join using Join Stage.

source1----->Join Stage------>Transformer------>Target
|
|
|
source2-----------

Full Outer Join on Source1.key=Source2.key

Now, in Transformer Stage, write in constraint tab for
source1, <any coulum of source2> IsNull, to collect the
unmatched records of source1.
&, write in constraint tab for source2, <any coulum of
source1> IsNull, to collect the unmatched records of
source2.

If you have any other doubt or query, mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

How do you schedule or monitoring the job?

1266

---

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

1428

---

What is aggtorec restructure operator?

1523

---

What is datastage engine?

1222

---

what is the use of skid in reporting?

2426

---

Notification Activity

1456

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1167

---

Could anyone give brief explanation bout datastage admin

2404

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2110

---

How do you remove duplicate values in datastage?

1194

---

What is the purpose of interprocessor stage in server jobs?

2289

---

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

2330

---

Can you explain engine tier in information server?

1181

---

What are constraints and derivations?

1210

---

What are the various kinds of containers available in datastage?

1100

---