WHAT IS FACT TABLES?

Answers were Sorted based on User's Feedback



WHAT IS FACT TABLES?..

Answer / siva

Fact table contains facts,measures or numerical vlues. Foe
example if your business process is 'sales' then a
measurment of this business process contains name of the
product,price of product,location and date and time of the
product sales.It also contains foreign keys of all the
dimension tables.

Is This Answer Correct ?    3 Yes 0 No

WHAT IS FACT TABLES?..

Answer / rekha

Fact table is the primary table in the dimensional
modeling . the numerical performance of measures of the
business stored in fact table
mostly used facts ara numeric and additive
not every numeric is a fact ,but a numeric wich ara of type
key performance indicator is called fact

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,


how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,


can u give example for factless fact table

2 Answers   TCS,






How many repositories can be created in informatica?

1 Answers  


What is decode in informatica?

0 Answers  


What does role playing dimension mean?

0 Answers  


Can you copy the session to a different folder or repository?

2 Answers  


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,


Categories