what is fact table?

Answer Posted / honey

A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables. Fact tables contain data that describes specific
events within a business, such as bank transactions or
product sales.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we remove the duplicates from flat file source?

583


Explain the scenario which compels informatica server to reject files?

660


What is the advantage of informatica?

650


How we can use union transformation?

612


What is dimensional table?

625






What are the issues you have faced in your project? How did you overcome those issues?

1917


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6421


What is depict expression change?

623


Explain lookup transformation is active in informatica

665


can we override a native sql query within informatica? Where do we do it? How do we do it?

601


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

1505


How big was your fact table

1322


What is a repository? And how to add it in an informatica client?

664


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1503


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

786