Why is there a restriction of 16 Dim tables in an Info Cube and 16 critical fields in an ODS?
SAP Online Classes provides Best SAP training Online based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. SOC is one of the most credible ERP SAP Online training provider, offering hands on practical knowledge and full job assistance with basic as well as advanced level ERP SAP Implementation Training. At SOC ERP SAP training Online is conducted by subject specialist corporate professionals with 14+ years of experience in managing real-time ERP SAP projects.
Why is there a restriction of 16 Dim tables in an Info Cube and 16 critical fields in an ODS?
Answer
Michael
Technical Specialist at Royal Dutch Shell
-
In all of the database systems, there is a maximum number of fields allowed to create a primary key (composite key) is 16. An in the case of a cube, to fetch a single record a combination of all dimensions is used, so this is the reason behind having maximum no. of dimension in the cube is 16 only.