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
What are the various types of transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is meant by pre and post session shell command?
What is session task and command task?
generate date / time dimension in informatica
What is a node in Informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
How can we update a record in the target table without using update strategy?
What does reusable transformation mean?
Explain Dataware house architecture .how data flow from intial to end?
What is InformaticaPowerCenter?
What is workflow manager?
What is the format of informatica objects in a repository?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is transformation?