tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
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(+);
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between operational data stage (ods) and data warehouse?
What are stage variables?
If you want to use a same piece of code in different jobs, how will you achieve this?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is ds designer?
Differentiate between data file and descriptor file?
How do y read Sequential file from job control?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
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
What is the importance of the exception activity in datastage?
What is the different type of jobs in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the roundrobin collector?
How do you schedule or monitoring the job?