in which situations do u go for starflake schema ?
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
Explain sql transformation in script mode examples in informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is meant by LDAP users?
How many types of sessions are there in informatica.please explain them?
What is the maplet?
What is the difference between router and filter?
What are connected or unconnected transformations?
Explain the aggregator transformation?
What is primary and backup node?
Explain the different kinds of facts.
What is meant by pre and post session shell command?
How you can differentiate between connected lookup and unconnected lookup?
How to implement security measures using repository manager?
What is the status code in stored procedure transformation?
What is main use of mapplet?