Answer Posted / kittu
It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we handle two sessions in informatica?
tell me the rules and responsblites in our project(my project is development)
What is target designer and target load order?
Explain in detail about scd type 1 through mapping.
Explain in detail scd type 2 through mapping.
Slowly changing dimensions, types and where will you use them
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a sorter transformation?
What are the different components of powercenter?
What is aggregator transformation in informatica?
Design time, run time. If you don't create parameter what will happen
Why filter transformation is an active one?
Explain lookup transformation source types in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?