WHAT IS FACT TABLES?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different options available for update strategy?

663


What is sorter transformation?

682


How to configure mapping in informatica?

773


Enlist the advantages of informatica.

728


what is song in infrmatica...?

1812






What is meant by a domain?

744


Enlist the differences between database and data warehouse.

639


What are the different versions of informatica?

797


What is confirmed fact in dataware housing?

5914


How to elaborate tracing level?

789


What is standalone command task?

818


Explain the types of transformations?

689


What is the reusable transformation?

735


How to improve the performance of a session using sorter transformation?

790


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

699