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
Explain a mapping, session, worklet, workflow, mapplet?
Explain me what are conformed dimensions?
What are the different types of schemas used in data warehousing?
What are data modeling and data mining? Where it will be used?
Compare aggregates and data marts
Explain what is power center repository?
What is MODEL is Data mining world?
Explain some of modeling tools available in the market?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
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 needs to be done while starting the database?
What is a data warehousing?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is the difference between star and snowflake schemas?