Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 8362 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
Explian the Process of deployment groups in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to join three sources using joiner? Explain though mapping flow.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is an aggregator transformation?
What is the need of an ETL tool?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the function of look up transformation?
What could be the possible resons of locks by user?
What are the main issues while working with flat files as source and as targets ?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Which is the t/r that builts only single cache memory?
Explain the informatica workflow?
Please let me know how to make Data masking in informatica..
