in which situations do u go for snowflake schema ?
Answer Posted / giri
it will used at time u will maitain normalised data u r
data having more cordinality dat tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
State the limitations where we cannot use joiner in the mapping pipeline?
EXL informatica Questions
What is meant by active and passive transformation?
What are the designer tools for creating transformations?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
On which transformations you created partitions in your project?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
can you please explain me pre session and post session options?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Name the different lookup cache(s)?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the difference between a repository server and a powerhouse?