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
Can you use flat files in Mapplets.
Where are the source flat files kept before running the session?
What are the tuning techniques you applied during your last project
What is informatica? Why do we need it?
Can informatica load heterogeneous targets from heterogeneous sources?
What are the reusable transformations?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to do the error handling of if ur source is flatfiles?
What are the informatica performance improvement tips
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the new features of informatica 9.x at the developer level?
How to create or import flat file definition in to the warehouse designer?