DSXchange

My question is when an Oracle connector loads data into memory at the start of an ISD job, if it ever gets refereshed when the referenced table is updated and if yes what is the mechanism.
Please let me know of any documents that may explain this.

Example;


ISD input --> lookup country/state ---> ISD output

The question is when 'lookup country/state' is updated after the service is deployed, if the lookup will reflect the change.
In another word if the normal lookup that is loaded into memory for an always on ISD job reflects the latest and greatest data in the table.

There is no refresh of normal lookups while the job is still running.

You would need to stop and restart the "always on" job to pick up any changes.

I suppose the Sparse lookups pickup the latest the changes. Right?

Yes.

It worked with the Sparse lookup.
Thank you all