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
- 9739 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
Can you explain tagbatch restructure operator?
What are transforms and what is the differenece between routines and transforms?
Differentiate between datastage and datastage tx?
What are the various kinds of the hash file?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the use of datastage director?
table actions available in oracle connector?
What is the project in datastage?
What is quality stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the difference types of stages?
how to sort two columns in single job in datastage.
Where the datastage stored his repository?
What are iconv and oconv?
How can we improve the performance in datastage?
