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

What is difference between query studio and report studio?

528


What are aggregate transformation?

572


Explain what are data marts?

585


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

518


What is the main difference between star and snowflake star schema? Which one is better and why?

554






Explain what is the difference between olap and datawarehosue?

601


Explain the difference between filter and conditin?

562


What are the various tools? Explain name a few?

536


What is the difference between static cache and dynamic cache?

516


What we will do with the universe for faster process?

565


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5466


What are data modeling and data mining? Where it will be used?

541


What is surrogate key? Where we use it explain with example?

485


How do you create surrogate key using ab initio?

543


What is index awareness in universe?

575