difference between For each and for all
Answers were Sorted based on User's Feedback
Answer / manshul goel
FOR EACH is considered as a "group by" in the SQL generated
while when we apply FOR ALL it generates SUMMARY on the
basis of the element
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Tell me what is full load & incremental or refresh load?
How to handle multi value dimensions?
What is a data warehousing?
what is parallel query?
Difference between ODS and Staging
Difference between e-r modeling and dimentional modeling?
What are the steps involved in designing a fact table?
What is drilling across?
What is Time Series algorithm in data mining?
What is fact less fact table? Where you have used it in your project?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?