what is fact table?

Answer Posted / m.sivakumar

The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are junk dimensions?

623


What is the difference between a repository server and a powerhouse?

798


what is index?how it can work in informatica

1571


What is DR strategy for Informatica project?

687


tell me the rules and responsblites in our project(my project is development)

1488






what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1766


How to partition the Session?

637


What is a filter transformation and why it is an active one?

553


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

995


How many input parameters can exist in an unconnected lookup?

980


Explain the different kinds of facts.

554


How to extract sap data using informatica?

595


my source is junk data how will u remove that junk data by using unix please any one replay me

3234


Can you use flat files in Mapplets.

2209


What is the surrogate key?

624