Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 9734 Views
- Polaris, I also Faced
- E-Mail Answers
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
Where do you see different stages in the designer?
What is the difference between odbc and drs stage?
How rejected rows are managed in datastage?
how to abort the job its matain duplicates?
How can one find bugs in job sequence?
What is merge stage?
how to sort two columns in single job in datastage.
Differentiate between datastage and informatica?
What are the functionalities of link partitioner?
What are datastage sequences?
Difference between in process and inter process?
Define meta stage?
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 purpose of pivot stage and types of containers in datastage
What is the purpose of interprocessor stage in server jobs?
