Caching in Lookup stage

[r.vikram87datastage]

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.

[suse_dk]

That is a sparse lookup in DataStage... and I think the Oracle Enterprise Stage supports it.

[r.vikram87datastage]

Hi suse_dk,


Thanks for helping me out....


Regards,
Vikram