WHAT IS FACT LESS FACT TABLE?

Answer Posted / rg

factless fact table contains only the keys of the dimension
table.
they do not contain any measures.
whereas fact table contains both dimension table keys and
also measures.

Is This Answer Correct ?    32 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is surrogate key? Where we use it?

581


What is the difference between connected and unconnected stored procedures?

559


Explain meta data?

557


What is factless fact tables?

642


What are the types of partitioning?

584






What are modeling tools available in the market?

571


Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

724


What is a data profile?

579


Explain what is the data type of the surrogate key?

590


What are the approaches used by optimizer during execution plan?

495


What are fundamental stages of data warehousing?

546


Explain what is data validation strategies for data mart validation after loading process?

611


Explain datawarehousing?

559


Explain what are the mapping paramaters and maping variables?

569


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

611