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 are factless facts? And in which scenario will you use such kinds of fact tables.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the sql query overwrite in source qualifier in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
Sequence generator, when you move from develoment to production how will you reset
What happens when a session fails and you click on recover?
How to do the error handling of if ur source is flatfiles?
Write the program through which the records can be updated?
update strategy transformation in informatica
What do you understand by term role-playing dimension?
What is persistent lookup cache?
Can you generate sequence numbers without using the sequence generator transformation?
How do you load only null records into target?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a node in Informatica?