What is high cardinality dimension?
Answers were Sorted based on User's Feedback
Answer / guest
Cardinality Dimension is defined as the ratio between number of
distinct values in a table to the number of rows in a that table.
I think this is the correct answer. If not please let us know
Is This Answer Correct ? | 14 Yes | 4 No |
Answer / anil
Number of possible dependent records of the check table in
relation with foreign key.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / shirisha
Dimension is stated to be of high cardinality if the number
of entries in it are more than 10% of the fact table.
In such cases, SAP converts that dimension respresentation
from bitmap to B tree index.
Bitmap representation takes larger storage space but very
simple and efficient for smaller set of values.
Is This Answer Correct ? | 11 Yes | 11 No |
How do you create a reusable structure from a local structure?
Can you tell something about the multi-provider in the sap and how it is useful for the users?
how do u deceided to go create Aggregates for cube. what purpose u want to create aggregates?
What is the importance of 0requid?
What is a typical setup of BW team?
What are the general tuning guidelines?
Can you create aggregate on ODS or multi provider?
How can you navigate to see the error idocs?
What is the number of decimal places in scaling factor?
What is the namespace of BW?
I have 10 cubes I created multiprovider I want only 1 cube data what u do?
What are the data types supported by characteristics?