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
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 the different types of lookups in datastage?
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)
Differentiate between datastage and informatica?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is size of a transaction and an array means in a datastage?
Differentiate between odbc and drs stage?
What are the job parameters?
How do you reject records in a transformer?
What is apt_config in datastage?
How the ipc stage work?
What is aggtorec restructure operator?
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 ?
Difference between data warehousing and olap?
EXPLAIN SCD
Can you filter data in hashed file?