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
What is a predefined event?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Define filter transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is the Default Source Option For Update Strategy Transformation?
Can u generate reports in Informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to join three sources using joiner? Explain though mapping flow.
Define pmcmd command?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How might you approve all mappings in the archive all the while?
What is primary and backup node?
difference between informatica 8.1.1 and 8.6
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project