Why should we use star schema in datawarehouse design?

Answers were Sorted based on User's Feedback



Why should we use star schema in datawarehouse design?..

Answer / arun

Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.

Space consumed is more than snow-flake

Is This Answer Correct ?    2 Yes 0 No

Why should we use star schema in datawarehouse design?..

Answer / jz

1) Query performance is high.
2) It consume less space compare to SnowFlake.

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More Informatica Interview Questions

Can you generate reports in Informatcia?

1 Answers  


What is transformation?

0 Answers  


What is a node in Informatica?

0 Answers  


Describe expression transformation?

0 Answers  


What are events in workflow manager?

1 Answers   Accenture, IBM,






How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  


What will be the approach?

0 Answers  


diffrence between command task and control task

1 Answers   iNautix,


can u give example for factless fact table

2 Answers   TCS,


In a concurrent batch if a session fails, can you start again from that session

1 Answers  


How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,


Categories