What are the different types of Fatcs?
Explain with example only
Answer Posted / nasa
Facts are 3
-Additive
-Semi Additive
-Non Additive
Additive:: A value which can sumd up at any dimension
Semi Additive:: A value which can sumd up at only some dimensions
Non Additive:: A value which can't sumd up at any dimension
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain which are the olap tools available that are supported by oracle?
What are the types of partitioning?
What is the purpose of Dataware Control?
What is Star Schema?
What are the differences between datamart vs. Reporting cube?
Why fact table is in a normal form?
What is dimension modeling?
Explain a linked cube?
Explain the difference between data ware house & data mart?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the difference between aggregate table and materialized view?
Explain what is the difference between power center & power mart?
Explain can report net connect multiple datasource at a time in report creation time?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Can we take backup when the database is opened?