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
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
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 we use mapping variables in informatica? Where do we use them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How are indexes created after completing the load process?
How can you validate all mappings in the repository simultaneously?
What is the commit type if you have a transaction control transformation in the mapping?
How does a rank transform differ from aggregator transform functions max and min?
How do you update the records with or without using update strategy?
What are junk dimensions?
How do you promote a non-reusable transformation to reusable transformation?
What are the components of workflow manager?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the prerequisite tasks to achieve the session partition?
Why update strategy and union transformations are active?