What are the different types of schemas?
Answer Posted / vignesh muralidharan
three types of schemas are availble.Star schema,star flake
schema & snow flake schema.
Star schema:It is highly denormalised,so we can retrieve
the data very fast.
Star flake schema:Only one dimension contain one level of
hierachy key.
Snow flake schema:It is highly normalised,so retrievel of
data is slow.
Is This Answer Correct ? | 34 Yes | 43 No |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Tell me about MD5 functions in informatica
How can we handle two sessions in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is degenerated dimension?
Explain the mapping variable usage example in informatica
Define filter transformation?
What are the guidelines to be followed while using union transformation?
Why update strategy and union transformations are active?
What is a joiner transformation?
What are the components of the workflow manager?
What is the difference between a connected look up and unconnected lookup?
Explain the etl program with few examples.
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 parallel processing in informatica?