Answer Posted / deepa
star schema has fact table in the middle and dimensions
around it which are denormalized.
normalized form of star schema is called snow flake star
schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
expain about the tune parameters?
How is union transformation utilized?
How you know when to use a static cache and dynamic cache in lookup transformation?
Could you explain what is enterprise data warehouse?
What is meant by active and passive transformation?
Enlist some properties of sessions.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is an Integration service in Informatica?
Explain pushdown optimization and types in informatica
explain about unit testing? in real time?
What are the new features of informatica 9.x developer?
write a query to retrieve the latest records from the table sorted by version(scd)
Whats there in global repository
Whats the difference between informatica powercenter server, repositoryserver and repository?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?