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
What is an Integration service in Informatica?
I have a flat file, want to reverse the contents of the flat file
What is the difference between STOP and ABORT options in Workflow Monitor?
What is an unconnected transformation?
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.
What is the benefit of partitioning a session?
Difference between Target-based loading and constraint-based loading?
What is native users?
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
What is the difference between Active and Passive transformation?
Explain sql transformation in script mode examples in informatica
Explain scd type 3 through mapping.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do we call shell scripts from informatica?
What is Session and Batches?