Answer Posted / p.suneetha roy
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.
There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.
Let me know if there are any more facts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can we create a Integration service without a Repository service and vice versa?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to load the data from people soft hrm to people soft erm using informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is an unconnected transformation?
What is difference between a gateway node and worker node?
What is a connected transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is native users?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
If informatica has its scheduler why using third party scheduler?
Design a mapping to load a target table with the following values from the above source?
server hot-ws270 is connect to Repository B. What does it mean?
On which transformations you created partitions in your project?
Describe data concatenation?