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
- 8427 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
if you use oracle sql*loader , how do you transform data with it during loading?
What is Analysis Services?
What is meta data and system catalog?
What is critical column?
Explain which are the olap tools available that are supported by oracle?
What is recovering sessions?
What are the various tools? Explain name a few?
What needs to be done while starting the database?
Explain the hierarchies level data warehousing.
Explain some of modeling tools available in the market?
Explain what is full load & incremental or refresh load?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is the difference between aggregate table and materialized view?
What is the difference between datawarehouse and bi?
What are the steps of implementing data warehousing?
