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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is union transformation in informatica?
How you can differentiate between connected lookup and unconnected lookup?
How can we create index after completion of load process?
Explain the shared cache and re-cache?
what is INFORMATICA TESTING process
What is sequence generator transformation in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is data movement mode in Informatica and difference between them?
Write the unconnected lookup syntax?
Define the various join types of joiner transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is DR strategy for Informatica project?
What are the different components of powercenter?
