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

Answers were Sorted based on User's Feedback



A table containg 100 records B table containg 20 records we have to join two tables in left outer i..

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

A table containg 100 records B table containg 20 records we have to join two tables in left outer i..

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

A table containg 100 records B table containg 20 records we have to join two tables in left outer i..

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

Post New Answer

More Data Stage Interview Questions

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,


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?

1 Answers   IBM,


hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  


How we can convert rows to columns in datastage?

4 Answers   IBM,


What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,






parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  


Is the value of staging variable stored temporarily or permanently?

0 Answers  


hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  


What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  


WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,


Categories