in which situations do u go for snowflake schema ?

Answers were Sorted based on User's Feedback



in which situations do u go for snowflake schema ?..

Answer / 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

in which situations do u go for snowflake schema ?..

Answer / giri

it will used at time u will maitain normalised data u r
data having more cordinality dat tables

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the meaning of up gradation of repository?

0 Answers  


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


Explain target update override in informatica

0 Answers   Informatica,


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  






Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


Explain the pipeline partition with real time example?

0 Answers   Informatica,


what is the significance of newlookup port in dynamic look up

1 Answers   IBM,


what is unique constraint error ?

2 Answers   TCS,


Categories