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 are the types of caches in lookup?
Differentiate between reusable transformation and mapplet.
How will the document be delivered to me?
Write the program through which the records can be updated?
Which version configuration tool used in ur project?
How to update source definition?
What the difference is between a database, a data warehouse and a data mart?
Explain lookup transformation in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is informatica powercenter repository?
Write the different tools in the workflow manager?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the components of the workflow manager?
What is a passive transformation?