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
How many transformations can be used in mapplets.
How to load last n records of file into target table - informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
Make a note of the quantity vaults made in informatica?
What are the advantages of informatica?
How can informatica be used for an organization?
What is the Process to creating lookup transformation in informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is a sorter transformation?
Separate from an archive server and a powerhouse?
What is meant by pre and post session shell command?
if we have a delimiters at unwanted places in a flat file how can we over come those.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is diff b/t sorter t/r and agg have the option sorter property...
How can you differentiate between powercenter and power map?
