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
What is the difference between STOP and ABORT options in Workflow Monitor?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a predefined event?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is update strategy transform?
what is mean by complex business rule ?
How to use procedural logic inside infromatica?
how we can load rejected record's at run time?(not through bad files)
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the components of the workflow manager?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a code page?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Which development components of informatica have the highest usage?
tell me the rules and responsblites in our project(my project is development)