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 |
how can u load the data in time dimension?
scd methodology?
How can we remove the duplicates from flat file source?
how do u move the code from development to production?
How to call shell scripts from informatica?
List the transformation in informatica.
Enlist the tasks for which source qualifier transformation is used.
How many cubes create from a single model?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
how to run the batch using pmcmd command
How to create Target definition for flat files?
What are the issues you have faced in your project? How did you overcome those issues?