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
- 9636 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / geetha
Extra 1 records is populated in case of duplicate records in the reference tables. lets say we have emp_id A in left table and we have two emp_id A ,in this case we will have duplicate records in the output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hirdesh srivastava
If you join two tables either equi join, left outer join or right outer join, result records can't be greater than max record of a big table. Until or unless you go for full outer join. e.g. if there are 100 records in one table and 20 records in other table then if you go for any join except full outer join result records won't be greater than 100 records.
| Is This Answer Correct ? | 3 Yes | 3 No |
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What is the version control how can i apply this in DataStage can any one tell me the anser
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
detail about sdlc
How one source columns or rows to be loaded in to two different tables?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
What is size of a transaction and an array means in a datastage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
What is exact difference between Parallel Jobs and server Jobs..
how can u connect the client system directly at any time?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Teradata 
