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
How can we delete duplicate rows from flat files?
Where do we use mapping variables in informatica?
Repository user profiles
What are the informatica performance improvement tips
What is aggregator transformation in informatica?
What are mapplets?
Can you use flat files in Mapplets.
Explain the informatica workflow?
How can you define user defied event?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How to generate sequence numbers using expression transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to differentiate between the active and passive transformations?
Briefly describe lookup transformation?
Can anyone tell me the new features in Informatica 9 Version?