lookup cache

[kpmINFO]

I do not want to cache lookup table data,
I tried disabling the cache in my lookup tr, I am getting an error saying that this is not yet supported by informatica.
I would like to know If I am doing anyting wrong.

Here is the scenario, I have a source with 20 records and my lookup is caching 12000000 records, I prefer not caching this lookup data. What is the best way out?

 

[Dagon]

If you are using an override, you will get this error. Uncached lookups are only supported without using an SQL override.

Obviously, you could get round the restriction by using a view.