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 |
For faster process, what we will do with the universe?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What are the advantages of query studio compared to report studio?
Data WareHousing course in noida
What is the differences between star and snowflake schemas?
Explain what are the steps to build the data warehouse?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
Compare and contrast aggregates & indexes
Difference between e-r modeling and dimentional modeling?
Explain the definition of normalized and denormalized view?
What are cluster analysis in data warehousing?
What is a staging area? Do we need it? What is the purpose of a staging area?