WHAT IS FACT LESS FACT TABLE?

Answer Posted / srinivas

a fact less fact table is a numeric and summerized value
but it is not a business measurment value.

example:

in emp bonus table is a fact less fact table.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to build the datawarehouse?

588


How can we run the graph?

589


How to create diff. Types of templates?

568


How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

547


Explain what are the various transformation available?

545






Explain vldb?

637


What is critical column?

681


Database in use is oracle?

611


What is a data profile?

579


What is Sequence clustering algorithm?

1550


What are data validation strategies for data mart validation after loading process?

542


Explain the importance of data warehouse?

576


What are the key features of chameleon that separates it from other algorithms?

677


What is pre-emptive and non-pre-emptive?

568


What is Operational Data Store?

607