Answer Posted / shishir
For each will process the statements for each row of the
bulk collect ,whereas for all will process all the records
in a single shot. These key work is generally used with the
bulk collections to enhance the preformance by minimizing
the I/O operations
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
How many types of facts and what are they?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain difference between data ware house & data mart?
What is edw?
Explain what is real time data-warehousing?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the reasons to use a chameleon method in data warehousing?
Who needs data warehousing?
What are session timeout and application timeout? Where we have to do this process?
Explain what is the metadata extension?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is a staging area? Do we need it? What is the purpose of a staging area?
What are the different types of fact tables used in data warehousing?
Explain what are the mapping paramaters and maping variables?
Why facts table is useful in representing the data?