Caching in Lookup stage
Posted: Mon Oct 17, 2011 11:07 am
Hi Guys,
I am new to datastage.
I am trying to migrate a job from SSIS to datastage.
In SSIS lookup there are two option called Full Cache and No cache.
Full Cache : Reference query will be fired in the beginning and will be stored in the cache.
No Cache : Reference query will be fired for each input record.
How can i achieve no cache in datastage lookup stage. I want the lookup data to get refreshed for each input record.
My target database is oracle and am using oracle enterprise stage.
Kindly help me out guys.
Thanks in advance,
Vikram.
I am new to datastage.
I am trying to migrate a job from SSIS to datastage.
In SSIS lookup there are two option called Full Cache and No cache.
Full Cache : Reference query will be fired in the beginning and will be stored in the cache.
No Cache : Reference query will be fired for each input record.
How can i achieve no cache in datastage lookup stage. I want the lookup data to get refreshed for each input record.
My target database is oracle and am using oracle enterprise stage.
Kindly help me out guys.
Thanks in advance,
Vikram.