One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?
No Answer is Posted For this Question
Be the First to Post Answer
whats the logic to load the lower level of granularity of data to fact table.
How can you define a transformation? What are different types of transformations in Informatica?
Whatis the difference between View and Materialized View ?
Is there any way to read the ms excel datas directly into informatica?
need for registering a repository server
what is surrogate id ?
How to generate a single mapping for both the historical and incremental load.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
what are the transformations that restricts the partitioning of sessions?
Explain the different lookup methods used in informatica?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
can we override a native sql query within informatica? Where do we do it?