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
- 8592 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
Explain er diagram?
What is data warehosuing hierarchy?
What are fundamental stages of data warehousing?
what are the all possible features supported modify stage?
Explain how are the dimension tables designed?
How to create different types of templates?
How to calculate fact table granularity?
What are non-additive facts in detail?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is meant by metadata in context of a data warehouse?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is crass reference table?
Explain bus schema?
Can a dimension table contain numeric values?
After the complete generation of a report who will test the report and who will analyze it?
