A table containg 100 records B table containg 20 records we
have to join two tables in left outer it containg target 100
records but target containg 101 record at that time what is
the issue arise
Answer Posted / srinivas
Hi,qustion was not clear.
As per my understanding After join if we get 101 records in target, then we can say one duplicate was there in B table.
While joining the tables by using left outer total records from left table and matched records from both will be load into target.
so i will give small example
We have two tables A & B
A having
Id Name
1 sri
2 hari
3 prasad
B Having
LeavesId
1
1
2
3
If will do the left outer join u will get below
No name leavesid
1 sri 1
1 sri 1
2 hari 2
3 prasad 3.
As per above example may help u to demonstrate the your query.
Thanks
Sri
Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
What is the difference between validated and compiled in the datastage?
table actions available in oracle connector?
project Steps,hits, Project level HArd things,Solved methods?
explain about citrix scheduling tool in datastage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is a ds designer?
What is the purpose of pivot stage and types of containers in datastage
What are the partitioning techniques available in link partitioner?
How a server job can be converted to a parallel job?
what is the use of skid in reporting?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Can you define merge?
Describe routines in datastage? Enlist various types of routines.
What is the sortmerge collector?
What are the enhancements made in datastage 7.5 compare with 7.0?