Answer Posted / suren
Fact table contains measurement of information
Factless table contians with out any measure.
1.Additive : Additive fact table contains the summarized
data.
2.Non Additive : Non Additive fact table contains without
additve data.it contains only detail data
3.SemidAdditive: Semi additive fact table contains both the
summarized data as well as detial data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many number of sessions can one group in batches?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is blocking transformation?
What is an Integration service in Informatica?
What is data movement mode in Informatica and difference between them?
What is informatica powercenter repository?
How can you define user defied event?
What are session parameters ? How do you set them?
What are the features of complex mapping?
What is a code page?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a repository? And how to add it in an informatica client?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Performance tuning in UNIX for informatica mappings?
Which development components of informatica have the highest usage?