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 |
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
How to load the data from people soft hrm to people soft erm using informatica?
explain abt union t/r?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What do you mean by blocking transformation?
what are the difference between Informatica 7.1 and 8.1?
What are the types of data warehouses?
Which are the different editions of informatica powercenter that are available?
how much memory (size) occupied by a session at runtime