WHAT IS FACT TABLES?
Answers were Sorted based on User's Feedback
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 |
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 |
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
can u give example for factless fact table
How many repositories can be created in informatica?
What is decode in informatica?
What does role playing dimension mean?
Can you copy the session to a different folder or repository?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
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.
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,