What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
Answer Posted / dirasanchu
It is a fact table which does not contain any measurable data.
EX: Student attendance fact (it contains only Boolean
values, whether student attended class or not ? Yes or No.)
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is ods (operation data source)?
What are target types on the server?
Explain the hierarchies level data warehousing.
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Store (and count) non-fact records?
What is data mart in data warehouse?
how much memory space occupied real time project (roughly)?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Can a dimension table contain numeric values?
What are diagrams?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
In document how to create metrics?
Explain what is the difference between datawarehouse and bi?
What is loop in data warehousing?
What is the main difference between schema in rdbms and schemas in datawarehouse?