Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 8127 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
Explain why we use partitioning the session in informatica?
Parameter and variable differences
Differentiate between router and filter transformation?
What is decode in informatica?
What is persistent lookup cache?
Explian the Process of deployment groups in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what are the deliverables?in your project?
How to elaborate tracing level?
What is session task and command task?
How to open an older version of an object in the workspace?
Plz can any one say me how to get the informatica certification materials and dumps
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.
