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 can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---

What is apt_config in datastage?

0 Answers  

---

Difference between data warehousing and olap?

0 Answers  

---

What is aggtorec restructure operator?

0 Answers  

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---

what is materialized view used datastage?

1 Answers   HSBC,

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

What is mapping?

3 Answers  

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---