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
- 9637 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 is the use of datastage designer?
What are some different alternative commands associated with "dsjob"?
Can you define merge?
What are transforms and what is the differenece between routines and transforms?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the different types of lookups in datastage?
Differentiate between validated and Compiled in the Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Describe the main features of datastage?
why do u need the IOS upgradation in a FC switch
What are datastage sequences?
What can we do with datastage director?
Notification Activity
What is the purpose of interprocessor stage in server jobs?
