What are the different types of schemas?
Answer Posted / ande
two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande
Is This Answer Correct ? | 71 Yes | 31 No |
Post New Answer View All Answers
Explain incremental aggregation in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the different kinds of facts.
How do you migrate data from one environment to another?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a filter transformation and why it is an active one?
If informatica has its scheduler why using third party scheduler?
What is the cumulative sum and moving sum?
What are the conditions needed to improve the performance of informatica aggregator transformation?
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?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is a passive transformation?
What is domain and gateway node?
What is the Process to creating lookup transformation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?