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
- 9576 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
Describe the architecture of datastage?
What is "fatal error/rdbms code 3996" error?
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?
Difference between in process and inter process?
How you Implemented SCD Type 1 & Type 2 in your project?
Explain Quality stage?
How many types of stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
In Datastage, how you can fix the truncated data error?
how to export or import the jobs in .ISX file
What is size of a transaction and an array means in a datastage?
What are the components of datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How a source file is populated?
What are routines in datastage?
