12. Partitioning

12. The following statements are true for partitioning.

a. If a cube has been partitioned, the E table of the info cube will be partitioned on time.
b. The F table of the info cube is partitioned on request.
c. The PSA tableis partitioned automatically with several requests on one partition.
d. It is not possible to partition the info cube after data has been loaded, unless all the data is deleted from the cube.

ANSWER(S): A, B, C, D, F

BW allows partitioning of the info cubes based on time. If the info cube is partitioned, the e-fact table of the info cube will be partitioned on the time characteristic selected.

The F fact table is partitioned on request ids automatically during the loads. PSA tables are also partitioned during the loads and can accommodate more than one request. For an info cube to be partitioned, all data needs to be removed from the info cube.

Return to the answer page
Return to the quiz

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Quizzes Quiz: SAP master data management (MDM) Quiz: SAP BI/BW -- advanced level SearchSAP.com SAP BI/BW quiz answers: advanced level Quiz: Customers and Call Centers Quiz: SAP BI/BW -- intermediate level Answers to a SearchSAP.com quiz: Get to know BP master data for CRM SearchSAP.com SAP BI/BW quiz answers: beginner level Quiz: SAP BI/BW -- beginner level 2. Reference and referred characteristics 1. Data sources SAP business information warehouse Four things SAP must consider before a Teradata acquisition SAP BW or third-party data warehouses a dilemma for SAP customers Should we install SAP BW on the same server running SAP R/3 4.7? SAP: Don't rush from SAP BEx tools to SAP BusinessObjects SAP shores up SAP NetWeaver BW with Teradata Choosing an SAP BI/BW database for InfoCube data Using Infoset to join, move DSO analysis to InfoCube Selecting InfoCubes in SAP BI/BW Business Content SAP BI roadmap one year later: How's Business Objects working out for SAP BI customers? How to limit employee access to reports using roles in SAP NetWeaver SAP business information warehouse Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary BEx  (SearchSAP.com) Business Information Warehouse  (SearchSAP.com) Enterprise Services Architecture  (SearchSAP.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary