Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 8125 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnansk
star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
What is a joiner transformation and why it is an active one?
What is blocking transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to join three sources using joiner?
Define sessions in informatica etl?
What is incremental aggregation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain your project of banking domian.
How will the document be delivered to me?
is it possible to index the data in cache of lkp transformation ?
How to load the data from a flat file into the target where the source flat file name changes daily?
have u done any performance tuning? how u ll do?
I have a flat file, want to reverse the contents of the flat file
What are the types of caches in lookup?
