Answer Posted / hari
partitioning enables the query to fetch the data
parallelly. if the query requires 12months of data and the
partition is based of 0calmonth, the query fetches the data
in 12 parallel processes, thery by reducing the time for
query output by 12 times in theory.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the differences between v1, v2, v3 jobs in extraction.
What are the steps in general to enhance data?
what is structure in reporting?
What are the steps to do the configuring third party (bapi) tools.
What is the procedure to create a data mart?
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?
How can a cube have partitioned for which the data already exists?
Is the user exit common for all data sources?
What does rollup do?
You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?
Where do we use infoset in bi system?
What is the process chain?
What is geographical information in the sap bw?
What is partitioning and what are the benefits of partitioning in an infocube?