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
Explain the shared cache and re-cache?
What is a standalone command task?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Why update strategy and union transformations are active? Explain with examples.
Is it possible to create multiple domains on a single Informatica server?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you promote a non-reusable transformation to reusable transformation?
can anyone explain me about retail domain project in informatica?
Why sorter is an active transformation?
Enlist some properties of sessions.
Separate from a database, an information bazaar, and an information stockroom?
can we override a native sql query within informatica? How do we do it?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
