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 use of surogate key in datastage
Name the command line functions to import and export the DS jobs?
Why do you need stage variables?
What is a quality stage in datastage tool?
How the ipc stage work?
What is the use of datastage designer?
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
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the different options associated with dsjob command?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the difference between operational data stage (ods) and data warehouse?
Differentiate between operational datastage (ods) and data warehouse?
Can you explain tagbatch restructure operator?
What are the types of containers?
CHANGE CAPTURE