tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
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
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the flow of loading data into fact & dimensional tables?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between informatica and datastage?
Define oconv () and iconv () functions in datastage?
What are stage variables and constants?
What is the command line function to import and export the ds jobs?
What are the steps required to kill the job in Datastage?
What are the components of ascential data stage?
What is the difference between account and directory options ?
Explain the situation where you have applied SCD in your project?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How many types of hash files are there?
Explain usage analysis in datastage?