How to answer the question how many fakt table in your
datawarehouse and what size it have?
- 3 Answers
- 7881 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yaseen mohammad
There are three types of facts
1) Additive fact-----------which adds all dimensions for getting meaning full sentence Ex: sales_amount which adds dimensions like product,store,time
2) semi additive fact-------which adds some dimensions for getting meaning full sentence
3) Non additive fact------which does not get meaning full sentence by adding dimensions
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / rose
Check this you have detail explanation
http://www.1keydata.com/datawarehousing/fact-table-types.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
There are 3 fact tables
Cumulative
Snapshot
Fact less fact table
| Is This Answer Correct ? | 3 Yes | 6 No |
What is factless fact schema?
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K
6 Answers Accenture, IBM, TCS,
How Materialized Views are linked with Oracle DataWare house?
What is a data warehousing?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
DWH architecture?
why oracle is the best database for data warehousing?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
How did you plan your Data ware house project?
What Oracle features can be used to optimize my Warehouse system?
What is an error log table in informatica occurs and how to maintain it in mapping?
Teradata 
