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

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different options associated with dsjob command?

1441

What are stage variables?

1203

What are some different alternative commands associated with "dsjob"?

1169

What are the components of datastage?

1123

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2261

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

What is the purpose of interprocessor stage in server jobs?

2233

What is "fatal error/rdbms code 3996" error?

1266

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244

What are the types of containers in datastage?

1191

How to reverse the string using SQL?

1533

What is the purpose of pivot stage and types of containers in datastage

1040

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

1504

Explain the situation where you have applied SCD in your project?

2040

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046