Interested to Buy Any Domain ? << Click Here >> for more details...
How to answer the question how many fakt table in your
datawarehouse and what size it have?
- 3 Answers
- 8707 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we have multiple application.cfm file in an application?
Explain difference between data ware house & data mart?
What is a general purpose scheduling tool?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
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
What is the purpose of Dataware Control?
What is type 2 version dimension?
Explain vldb?
How to handle multi value dimensions?
What is the difference between connected and unconnected stored procedures?
Explain bus schema?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What is the difference between power center and power mart?
What is data stream and data adaopter?
What are the different types of fact tables used in data warehousing?
