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 please explain me pre session and post session options?

3 Answers   BTBP,


how can we use sorter transformation in joins?

5 Answers   IBM,


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


Separate from a database, an information bazaar, and an information stockroom?

0 Answers  






What is the status code in stored procedure transformation?

0 Answers   Informatica,


version controlling in informatica?

3 Answers  


normalizer transformation

3 Answers   CTS,


what is data driven?

1 Answers  


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


what are the settiings that u use to cofigure the joiner transformation?

2 Answers  


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


Categories