how to create a dynamic lookup in Datastage

[abha.kalra]

Hi,
i m created a hash file from the real time Database. i want that every time an entry is made in database should be reflect in hash file made in datastage without resetting the job or connection. can it be done in datastage?

[kcbland]

Can it be done, yes. Is it worth the effort, probably not. A realtime connection from the database either needs DS RTI, or you're going to need to embed triggers in the database to feed updates to either a queue or a queue table and use microbatches to continuously query the table and feed to the hash file. However, during hash updates, either you're going to have to introduce row level locking defeating all caching, or guarantee queries against the hash file will only occur between refresh cycles.

Why do you think you need to do this?