Why should we use star schema in datawarehouse design?
Answer Posted / 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 |
Post New Answer View All Answers
What if the source is a flat-file?
On which transformations you created partitions in your project?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the components of the workflow manager?
Parameter and variable differences
Explain transaction control transformation in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is joiner change?
What is update strategy transform?
While migrating the data from one environment to another environment how would you manage the connections?
What is the need for an etl tool?
Describe data concatenation?
how many types of dimensions are available in informatica?
whats the logic to load the lower level of granularity of data to fact table.
What do you mean by channel change?