Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS FACT TABLES?
- 2 Answers
- 6501 Views
- I also Faced
- E-Mail Answers
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 |
How many input parameters can exist in an unconnected lookup?
How can a transformation be made reusable?
What are the uses of etl tools?
Using Connected or unconnected lookup for performance wise which one is preferable?.
why we use materialized view over view?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
What is the difference between informatica 8.x and 9.x
What is Cognos script editor?
What is the difference between unicode & ascii mode data movement in informatica?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
If the records doesnt satisfy the filter condition where will it go?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Teradata 
