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
- 8167 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are data elements?
Define repository tables in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How rejected rows are managed in datastage?
What is quality stage?
how to sort two columns in single job in datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are system variables and sequencers in datastage
what is 'reconsideration error' and how can i respond to this error and how to debug this
explain about citrix scheduling tool in datastage
What is active and passive stage?
Terminate Activity
What is aggtorec restructure operator?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
