Answer / 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;

Answer / subhash

OUTPUT:

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

Answer / 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 many types of sorting methods are available in datastage?

0 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

What is ibm datastage?

0 Answers  

---

How the ipc stage work?

0 Answers  

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

what is the use of surogate key in datastage

3 Answers  

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

What are the different types of lookups in datastage?

0 Answers  

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

What are the types of containers in datastage?

0 Answers  

---