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

3 Answers
8856 Views
Infotech, I also Faced
E-Mail Answers

Answer Posted / subhash

OUTPUT:

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

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why fact table is in normal form?

1238

What is difference between server jobs & parallel jobs?

1032

Explain ibm infosphere information server and highlight its main features?

1086

Differentiate between odbc and drs stage?

1046

What are the different type of jobs in datastage?

1041

Name the different sorting methods in datastage.

1046

What are the types of containers and how to create them?

974

Where the datastage stored his repository?

1084

In Datastage, how you can fix the truncated data error?

1155

If you want to use a same piece of code in different jobs, how will you achieve this?

1274

How do y read Sequential file from job control?

15955

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2227

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3746

What is the difference between operational data stage (ods) and data warehouse?

1239

what is the custome stage in datastage? how can we impliment that one? plz tell me

2365