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
- 8219 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
Differentiate between odbc and drs stage?
Differentiate between operational datastage (ods) and data warehouse?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is difference between join, merge and lookup stage?
sed,awk,head
What are the different type of jobs in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the various kinds of the hash file?
Define repository tables in datastage?
What is the different type of jobs in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the enhancements made in datastage 7.5 compare with 7.0?
How can we improve the performance in datastage?
Which warehouse using in your datawarehouse
Name the different sorting methods in datastage.
