in which situations do u go for snowflake schema ?
Answer Posted / bala
If suppose we are having the multiple Fact tables and
multiple dimension tables normalized data ; we can go for
snowflake schema.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
What is union transformation in informatica?
Explain what are the different types of transformation available in informatica.
What is an active transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is flashback table ? Advance thanks
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
During the running session, output files are created by informatica server. Enlist few of them.
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 you know when to use a static cache and dynamic cache in lookup transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Could you explain what is enterprise data warehouse?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to extract the informatica rejected data?
What are the different components of powercenter?