What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
- 6 Answers
- 12522 Views
- ACS, I also Faced
- E-Mail Answers
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
Which columns go to the fact table and which columns go the dimension table?
What needs to be done when the database is shutdown?
What is index awareness in universe?
What is an error log table in informatica occurs and how to maintain it in mapping?
I have two universes created by two difference database can we join them in designer & report level? How
What is the 4 + 1 view model as it relates to system modeling?
Explain the differences between normalizer and normalizer transformation?
Can any one explain the hierarchies level data warehousing.
Explain dimension table ?
Difference between cold fusion 5 and cold fusion mx 6?
Explain when do we analyze the tables? How do we do it?
Where we use surrogate key explain with example?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is the data type of the surrogate key?
What is the difference between data warehouse and operational systems?
