Answer Posted / saif
uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain lookup transformation in informatica
What is the use of target designer?
Explain sql transformation in script mode examples in informatica
Performance tuning( what you did in performance tuning)
What are the tasks that source qualifier perform?
What is workflow monitor?
what is mean by complex business rule ?
How to load last n records of file into target table - informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is rank transform?
What are the types of data warehouses?
What are the guidelines to be followed while using union transformation?
What do you understand by term role-playing dimension?
What is the reusable transformation?
Explain informatica architecture - version 8 / 9