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 |
What is the purpose of geographical information in the sap bw?
What is the time distribution option in update rule?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
what is fullform of sap & college, institute of sap course
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
What are the template options?
What are the data loading tuning one can do?
what is E_T_RANGE?
What is the transaction to check delta?
What is the use of the info area in the sap bw system?
what is the difference between pdf and excel format after saving the report?
what are the different components in dso architecture?