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


Please Help Members By Posting Answers For Below Questions

What is data warehouse architecture?

566


Explain what is analytical or analytic mean?

569


Where we use surrogate key explain with example?

567


What is real-time datawarehousing?

594


What is surrogate key? Where we use it?

561






How can you set the session management?

565


Explain what is the limit to the number of sources and targets you can have in a mapping?

532


How can we run the graph? How can we schedule the graph in unix?

490


What are session timeout and application timeout? Where we have to do this process?

588


Explain what are the advantages data mining over traditional approaches?

666


Explain the difference between keylokup and joiner?

491


Where do we use semi and non additive facts?

575


What is the difference between drill through and masterdetail reports?

527


Compare aggregates and data marts

2261


Where the applications and where ware house management system is used?

518