WHAT IS FACT TABLES?
- 2 Answers
- 5481 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 unicode & ascii mode data movement in informatica?
What is Code Page Compatibility?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
How do you create single lookup transformation using multiple tables?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
In which scenario did you used pushdown optimization?
how can we use sorter transformation in joins?
What is difference between a connected look up and unconnected look up?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
how to load only the first and last record of a flat file into the target?
What is the reusable transformation?
Teradata 
