Answer Posted / m.sivakumar
The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
How can we handle two sessions in informatica?
what is song in infrmatica...?
How do you promote a non-reusable transformation to reusable transformation?
without table how to come first record only in oracle?
define galaxy repository in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is a filter transformation and why it is an active one?
What is fact table? Explain the different kinds of facts.
what is Active lock explain
What is a transaction control transformation?
What is a mapplet/worklet in informatica?
What are the static cache and dynamic cache in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
