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
- 9486 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 "fatal error/rdbms code 3996" error?
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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How do you start developing a datastage project?
Which commands are used to import and export the datastage jobs?
Enlist various types of routines in datastage.
In Datastage, how you can fix the truncated data error?
Why do we use link partitioner and link collector in datastage?
Define project in datastage?
How to manage date conversion in Datastage?
how to delete one row in target dataset
How rejected rows are managed in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between account and directory options ?
