Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for starflake schema ?
- 6 Answers
- 19854 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vidyanand
Mostly preferable is Star schema where query performance
will be high comparing to snowflake Schema.
Snowflake schema is used only where performance issue will
not come into matter.
So, better to use star schema rather than snowflake schema.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you take back up of repository?
What is workflow? What are the components of the workflow manager?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is degenerated dimension?
How to do the error handling of if ur source is flatfiles?
What is the different lookup cache(s)?
what is the hint? how to use it to reduce the query processing in program?
What is Data Caches size?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is workflow? What are the components of workflow manager?
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.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the types of schemas we have in data warehouse.
