Can i create a lookup table without cache.

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


Please Help Members By Posting Answers For Below Questions

Explain lookup transformation in informatica

650


What is the use of target designer?

611


Explain sql transformation in script mode examples in informatica

607


Performance tuning( what you did in performance tuning)

1489


What are the tasks that source qualifier perform?

633






What is workflow monitor?

603


what is mean by complex business rule ?

1723


How to load last n records of file into target table - informatica

600


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?

602


What is rank transform?

603


What are the types of data warehouses?

948


What are the guidelines to be followed while using union transformation?

643


What do you understand by term role-playing dimension?

583


What is the reusable transformation?

632


Explain informatica architecture - version 8 / 9

673