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 Target definition for flat files?
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?
Describe an informatica powercenter?
Explain the use of aggregator cache file?
How does a rank transform differ from aggregator transform functions max and min?
Is it possible to use a client with different version than that of its Informatica server?
what is the size of your data warehousing?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What do you understand by SOA of Informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is repository manager?
can we override a native sql query within informatica? How do we do it?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can we override a native sql query within informatica?
Mention some types of transformation?