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
- 9575 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
Distinguish between informatica & datastage. Which one would you choose and why?
How to manage date conversion in Datastage?
What is "fatal error/rdbms code 3996" error?
What are constraints and derivations?
Explain ibm infosphere information server and highlight its main features?
what is 'reconsideration error' and how can i respond to this error and how to debug this
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between Datastage 7.5 and 7.0?
Lookup constraints
What all are the different way to run a job?
What all the types of jobs you developed?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the types of jobs we have in datastage?
Triggers,VIEW,Procedures
