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
- 9485 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
Define repository tables in datastage?
Explain connectivity between datastage with datasources?
What is the flow of loading data into fact & dimensional tables?
What are the various kinds of the hash file?
how can we create rank using datastage?what is the meaning of rank?
What is apt_config in datastage?
What is the difference between hashfile and sequential file?
How many types of sorting methods are available in datastage?
How can one find bugs in job sequence?
What is orabulk stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Describe link sort?
What is difference between join, merge and lookup stage?
How do you import and export the datastage jobs?
What is the use of datastage director?
