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

Explain the types of lookup transformation?

560


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1737


what is mean by complex business rule ?

1713


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964


What is pmcmd command?

668






Slowly changing dimensions, types and where will you use them

1264


Can anyone tell me the new features in Informatica 9 Version?

1524


What are the differences between joiner transformation and source qualifier transformation?

620


how many types of dimensions are available in informatica?

555


explain abt ur project architecture?

1752


Write the unconnected lookup syntax and how to return more than one column.

590


Explain why we use partitioning the session in informatica?

607


What are the different versions of informatica?

670


What is data movement mode in Informatica and difference between them?

616


How union transformation is used?

583