Answer Posted / karthi

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 do you register plug-ins?

934

---

What is the difference between Datastage 7.5 and 7.0?

1064

---

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

1844

---

What are stage variables?

1153

---

What are the benefits of datastage?

1199

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1458

---

What is the difference between orabulk and bcp stages?

986

---

How do you import and export data into datastage?

1189

---

What all the types of jobs you developed?

1131

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2340

---

explain about citrix scheduling tool in datastage

2398

---

What are the types of containers?

1160

---

What are the important features of datastage?

1065

---

What is the difference between account and directory options ?

1128

---

Name the third party tools that can be used in datastage?

1037

---