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 the different plug-ins stages used in your projects?

1078

---

Which warehouse using in your datawarehouse

2185

---

What are orabulk and bcp stages?

1124

---

How to read multiple files using a single datastage job if files have the same metadata?

1252

---

What is aggtorec restructure operator?

1452

---

root tree will find which is server job and which is parallel job?

1967

---

Define Merge?

1317

---

What is the difference between hashfile and sequential file?

1260

---

How to reverse the string using SQL?

1526

---

What are the steps required to kill the job in Datastage?

1218

---

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

2865

---

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

1235

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

---

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?

2179

---

What is the difference between Datastage 7.5 and 7.0?

1096

---