Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS FACT TABLES?
- 2 Answers
- 6508 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 |
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
What is workflow monitor?
Are there any types of Dynamic Caches in informatica
What is the difference between a table and the materialized view?
What does refresh system mean, and what are its distinctive choice?
What is sequence generator transformation in informatica?
How are parameters defined in informatica?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
How you can differentiate between connected lookup and unconnected lookup?
What are the differences between oltp and olap?
How to delete first 3 rows & last 3 rows in target table in informatica
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Teradata 
