Why should we use star schema in datawarehouse design?
Answers were Sorted based on User's Feedback
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 |
Answer / jz
1) Query performance is high.
2) It consume less space compare to SnowFlake.
Is This Answer Correct ? | 4 Yes | 6 No |
Can you generate reports in Informatcia?
What is transformation?
What is a node in Informatica?
Describe expression transformation?
What are events in workflow manager?
How to Join Tables my Source is having 15 table target is one?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What will be the approach?
diffrence between command task and control task
can u give example for factless fact table
In a concurrent batch if a session fails, can you start again from that session
How can i set break points in debugging mode ? can explain steps please?