Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sathish
Star Schema
Star Schema is the type of modeling where we follow the
complete de-normalization process.A star schema contains
multiple dimensions which share the same fact table.
Say per example in the sales analysis star schema, the
actual sales goes into fact and the customer, product, date,
sales force information goes as dimensions.
Snowflake Schema
In order to strike a balance between 3rd normal form data
model and star schema, we have snow flake schema which is
more of normalized star schema. Even in snow flake we will
have the fact and dimension only big difference is the
dimension tables are normalized.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Informatica Checkpoints
Clarify the aggregator change?
Does an informatica transformation support only aggregate expressions?
Tell me about Propagate functions in informatica
waht type of interface is used for testing the data in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
Define Pmrep command?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are session parameters ? How do you set them?
What are the guidelines to be followed while using union transformation?
r u done any partitions in ur project?
How can you define user defied event?
What are the different options available for update strategy?
What are the data movement modes in informatica?
