Is snow flake or star schema used?
If star schema means why?
Answer Posted / senthil
hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..
star schema used in data warehousing ..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to elaborate tracing level?
What are connected or unconnected transformations?
Describe expression transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can we use batches?
What is rank index in rank transformation?
Mention few advantages of router transformation over filter transformation.
What is the difference between a repository server and a powerhouse?
What are the types of schemas we have in data warehouse and what are the difference between them?
can u give example for factless fact table
What are the settings that you use to configure the joiner transformation?
What are the mapping parameters and mapping variables?
How to load the data from people soft hrm to people soft erm using informatica?
State the differences between sql override and lookup override?