in which situations do u go for snowflake schema ?

Answer Posted / bala

If suppose we are having the multiple Fact tables and
multiple dimension tables normalized data ; we can go for
snowflake schema.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you change a non-reusable transformation to reusable transformation?

606


Different sorts of metadata that stores in the storage facility?

574


wat are deployement groups in informatica, how it will be used for developers

1267


What is resilience time?

669


What is the command used to run a batch?

583






Enterprise data warehouse your projects phase by phase explain?

1480


What is a sorter transformation?

677


How to update source definition?

643


tell me 5 session failure in real time how can you solve that in your project?

1642


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10286


What is a dimensional model?

587


What is different between the data warehouse and data mart?

641


How to do the error handling of if ur source is flatfiles?

1519


What is joiner change?

693


What is intricate mapping?

597