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
What is ods (operation data source)?
What according to you might be the future of data warehousing?
Explain a linked cube?
What is the main difference between inmon and kimball philosophies of data warehousing?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How to know the time taken for particular report execution?
Explain what are the different types of join operations?
What is a real-time data warehouse?
Explain what are the tasks that loadmanger process will do?
I need to set predefined condition. How I do this?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is a full backup?
Where the applications and where
What is the differences between star and snowflake schemas?