What are the different types of schemas?
Answer Posted / ande
two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande
| Is This Answer Correct ? | 71 Yes | 31 No |
Post New Answer View All Answers
What is complex mapping?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain lookup transformation is active in informatica
Why update strategy and union transformations are active? Explain with examples.
How to elaborate powercenter integration service?
What do you understand by SOA of Informatica?
Different sorts of metadata that stores in the storage facility?
How to differentiate between the active and passive transformations?
How an expression transformation differs from aggregator transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Why sorter is an active transformation?
How to use procedural logic inside infromatica?
What are Dimensional table?
What is an Integration service in Informatica?
can u give example for factless fact table