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.
Caching in Lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Sat Sep 24, 2011 10:41 am
Caching in Lookup stage
Vikram
-
- Participant
- Posts: 18
- Joined: Sat Sep 24, 2011 10:41 am