Answer Posted / 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 |
Post New Answer View All Answers
What is meant by lookup transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
have u done any performance tuning? how u ll do?
How we can create indexes after completing the load process?
What are the issues you have faced in your project? How did you overcome those issues?
What are the advantages of informatica?
What is a filter transformation and why it is an active one?
What is the need for an etl tool?
wat are deployement groups in informatica, how it will be used for developers
Explain the tuning lookup transformation - informatica
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 can we handle two sessions in informatica?
What are different types of transformations available in informatica?
What are the types of schemas we have in data warehouse.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks