Answer Posted / reddymkl.dwh

Use Full outer join
Right ------------->X table
| |
| |
Left--> Join----->Filter---------->Y table
|
|
Z table

Left.colname=Right.colname

Right.colname='' (A-B)
Left.colname<>'' and Right.colname<>'' (A intersection B)
Left.colname<>'' (B-A)

Will get desired output

Please correct if am wrong....

What are datastage sequences?

1056

---

Differentiate between validated and Compiled in the Datastage?

1192

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2175

---

Can you filter data in hashed file?

3720

---

How to RD using transformer?

1363

---

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

2924

---

what is the use of skid in reporting?

2307

---

sed,awk,head

1408

---

On which Dimension Table you implemented SCD Type in your Project

1969

---

What are the steps needed to create a simple basic datastage job?

1158

---

How to manage date conversion in Datastage?

1068

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2127

---

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

1294

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2129

---

What is difference between symmetric multiprocessing and massive parallel processing?

1079

---