what is fact table?

Answer Posted / gp

The table contain measurable data(facts) is called fact
table .

These facts defined three types : Additive

Non Additive

Semi additive facts

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Integration service in Informatica?

680


I have a flat file, want to reverse the contents of the flat file

666


What is the difference between STOP and ABORT options in Workflow Monitor?

670


What is an unconnected transformation?

640


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

998






What is the benefit of partitioning a session?

600


Difference between Target-based loading and constraint-based loading?

534


What is native users?

701


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1594


What is the difference between Active and Passive transformation?

607


Explain sql transformation in script mode examples in informatica

575


Explain scd type 3 through mapping.

555


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

604


How do we call shell scripts from informatica?

571


What is Session and Batches?

631