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 surrogate key? Explain with examples.

605


What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

571


What are the types of dimensional modeling?

612


What are Aggregate tables?

684


How we are using this function?

594






Explain the hierarchies level data warehousing.

506


Explain what is the main difference between inmon and kimball philosophies of data warehousing?

522


For faster process, what we will do with the universe?

568


What is Discover and Execute in XMLA?

1781


Compare and contrast aggregates & indexes

3341


what are relationships?

598


Code the tables statement to produce a multi-level frequency?

542


How to export mappings to the production environment?

502


Explain the data type of the surrogate key?

567


What is operational data store (ods)?

561