Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 8094 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How can you validate all mappings in the repository simultaneously?
Is there any way to read the ms excel datas directly into informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is unit testing?tell me proceedure
Performance tuning( what you did in performance tuning)
What is target designer and target load order?
what is SDLC way of code development?
What are the databases that informatica can connect to windows?
How to create Target definition for flat files?
What are the different ways to implement parallel processing in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the limitations of joiner transformation?
