What is Factless fact table ???
Answer Posted / aneesh
A factless fact table is fact table that does not contain
fact.They contain only dimesional keys and it captures
events that happen only at information level but not
included in the calculations level.just an information about
an event that happen over a period.
Refer the below site to get a better idea
dwhlaureate.blogspot.in/2012/08/factless-fact-table.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Could you explain what is enterprise data warehouse?
What are the prerequisite tasks to achieve the session partition?
Differentiate between a repository server and a powerhouse?
What is the difference between Active and Passive transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to load data in informatica ?
What is the way to execute pl/sql script using informatica mapping?
Clarify the aggregator change?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is mapplet in informatica?
What are the types of data warehouses?
What is workflow monitor?
What is the different lookup cache(s)?
What are the measure objects?