WHAT IS FACT LESS FACT TABLE?

Answer Posted / abhi thakur

A fact less fact table that does not contain fact.They
contain only dimensional key and it captures events that
happens only at information level but not included in the
calculation level.Fact less fact table are used for tracking
a process or collecting states.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In a star schema, are foreign key constraints between facts and dimensions neccessary?

545


What is the use of tabular model, tabular sql, tabular reference in real time application?

520


Explain what is analytical or analytic mean?

588


Compare and contrast aggregates & indexes

3347


What is bi?

574






Explain me what is vldb?

524


Explain what are the advantages and disadvantages of reporting directly against the database?

574


What are the tools available for etl?

546


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

563


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

535


Explain what is ods (operation data source)?

553


What are the methodologies of data warehousing?

574


What is the difference between dependent data warehouse and independent data warehouse?

607


Explain what is the data type of the surrogate key?

583


What is data analysis? Where it will be used?

559