WHAT IS FACT TABLES?

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


Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6749


What is pmcmd command?

671


Which transformation is needed while using the Cobol sources as source definitions?

726


What are mapplets?

815


Can you use flat files in Mapplets.

2215






Name the different lookup cache(s)?

704


What is a node in Informatica?

619


What are the popular informatica products?

648


What is difference between a gateway node and worker node?

620


What is native users?

721


What is the procedure for creating independent data marts from informatica 7.1?

563


Repository user profiles

1373


Explain transaction control transformation in informatica

760


Clarify the aggregator change?

592


What is the command used to run a batch?

573