Interested to Buy Any Domain ? << Click Here >> for more details...
what is a dimension table and types? explain about line
item dimension and high cardinality and uses, in which case
suppose to be use?
- 1 Answers
- 5163 Views
- I also Faced
- E-Mail Answers
Answer Posted / shri
Dimension table which holds character infobjects...
Types of Dimension tables..
Time dimension
Unit dimension
Package dimension
Line item dimension
when the dimension table contains more than 20% size of
fact table then it is a line item dimension..
in line item dimension table we will have only one
character info object..
scenario..
document number in granular infocubes..
customer numbers in coustmer-centric business like
telecommunications,banking and insurance...
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the function of the ‘reconstruction’ tab in an info cube?
How do you convert web objects from 2.x to 3.x?
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?
What are value fields?
which patch u used presently? How can I know which patch that one?
How would you know if a segment/segment level entry has been summarized?
what is performance tuning and the tools supposed to be used? and explain in detailed about aggregates, bw statistics and bi accelerator? uses of those tools?
What is the Bex options for characteristics like F4 help for query definition and execution?
What is proposed from statistics for aggregates?
What are the other BW processes?
What are the do?s and don?ts?
What are transfer rules?
What are the flags for general reporting?
What are the options when defining aggregates?
hierarchies are not there in bi?why
