Interested to Buy Any Domain ? << Click Here >> for more details...
difference between For each and for all
- 2 Answers
- 9438 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 |
What is data warehouse architecture?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What are the steps to build the datawarehouse?
Why denormalization is promoted in universe designing?
What are the various methods of getting incremental records or delta records from the source systems?
What is partitioning? What are the types of partitioning?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain is fact table?
Compare ?Data mining? and ?Data Warehousing??
Explain which columns go to the fact table and which columns go the dimension table?
How to pivot row data using informatica?
What are the other names given to data warehousing?
Teradata 
