Interested to Buy Any Domain ? << Click Here >> for more details...
difference between For each and for all
- 2 Answers
- 9549 Views
- I also Faced
- E-Mail Answers
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 |
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what are the various transformation available?
Explain the definition of normalized and denormalized view and what are the differences between them?
In document how to create metrics?
Explain differences between star and snowflake schemas?
What is the difference between olap and datawarehosue?
What are various warehousing tools?
Explain what are the basic needs to join two sources in a source qualifier?
What are the mapping paramaters and maping variables?
what are the other factors of the database on which the loading performance depend?
Explain can report net connect multiple datasource at a time in report creation time?
Explain what are the advantages of query studio compared to report studio?
Teradata 
