Answer Posted / subhash

OUTPUT:
1, a, d
2, b, NULL
3, NULL, c

SQL Query:
SELECT * FROM TAB1 FULL OUTER JOIN TAB2 ON
TAB1.key_column=TAB2.key_column;

or

SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column=TAB2.key_column(+)
UNION
SELECT * FROM TAB1,TAB2 WHERE
TAB1.key_column(+)=TAB2.key_column;

How many Key we can define in remove duplicate stage?

1379

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1084

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2365

---

What is a merge?

1161

---

Highlight the main features of datastage?

1158

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408

---

Describe the architecture of datastage?

1002

---

Differentiate between hash file and sequential file?

1068

---

What is the process of killing a job in datastage?

1016

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2718

---

What is the project in datastage?

1109

---

What is the difference between informatica and datastage?

1218

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1082

---

What is "fatal error/rdbms code 3996" error?

1264

---

What is difference between join, merge and lookup stage?

1092

---