Reference Oracle connector lookup in an ISD job (always on)

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
iShoreETL
Premium Member
Premium Member
Posts: 36
Joined: Wed Sep 05, 2012 9:40 pm

Reference Oracle connector lookup in an ISD job (always on)

Post by iShoreETL »

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.
iShoreETL
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
iShoreETL
Premium Member
Premium Member
Posts: 36
Joined: Wed Sep 05, 2012 9:40 pm

Post by iShoreETL »

I suppose the Sparse lookups pickup the latest the changes. Right?
iShoreETL
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
iShoreETL
Premium Member
Premium Member
Posts: 36
Joined: Wed Sep 05, 2012 9:40 pm

Post by iShoreETL »

It worked with the Sparse lookup.
Thank you all
iShoreETL
Post Reply