Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9487 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 session parameters ? How do you set them?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is index?how it can work in informatica
What is rank transformation in informatica
What is meant by lookup transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are pre and post-session shell commands?
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?
Differentiate between a repository server and a powerhouse?
What is resilience time?
According to his methodology what all you need before you build a datawarehouse
What is a transaction control transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How can you validate all mappings in the repository simultaneously?
