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 settings that you use to configure the joiner transformation?
what is the size of your data warehousing?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Which development components of informatica have the highest usage?
How are the sources and targets definitions imported in informatica designer?
What is dimensional table? Explain the different dimensions.
What are the uses of etl tools?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What will be the approach?
What is the Process to creating lookup transformation in informatica
How can you validate all mappings in the repository simultaneously?
Can we override a native sql query within informatica?
To import the flat file definition into the designer where should the flat file be placed?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab