Is snow flake or star schema used?
If star schema means why?
Answer Posted / radhakrishnansk
star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
What are the differences between joiner transformation and source qualifier transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is sorter transformation?
What is a surrogate key?
Differentiate between a database and data warehouse?
How can one identify whether mapping is correct or not without connecting session?
What is data caches/ index caches?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Whats there in global repository
What is olap (on-line analytical processing?
What are the components of Informatica? And what is the purpose of each?
What are the modules in Power Center