Big Lookup table problem-ver4.7

[cogprog]

Hi ,
we are using Informatica powermart Ver4.7. We are trying to use a big table as a lookup. Powermart is taking too much time to get into its cache. Can we choose not to cache the table with "ver4.7" and still do the lookup. If yes , How can it be done.

cogprog

 

[djlocke]

Hi,

you can use a non-cached lookup either in the session or in the mapping. Just unmark the "Lookup caching enabled" option on the Transformations tab.

If possible, consider using the lookup table in the source qualifier as a source table. If you do so, the lookup table will be joined by the database which in your case is much more performant than a non-cached lookup.

Rgds.
Juergen