Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?

Question Posted / subhash

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;

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usage analysis in datastage?

1061

What is the difference between in process and inter process?

915

What are the functionalities of link collector?

855

What is the difference between an operational datastage and a data warehouse?

877

table actions available in oracle connector?

1373

What is the roundrobin collector?

861

what is ds administrator used for?

936

Can you define merge?

881

Different ways a project can be moved to production ?...example ….export-import and Version control.

2199

How will you move hashed file from one location to another location?

1904

What is the precedence of stage variables,derivations, and constraints?

821

What are sequencers?

844

What is the use of datastage director?

802

What is quality stage?

771

Have you have ever worked in unix environment and why it is useful in datastage?

918