Originally posted by: muralee

is there anyway to do caching in TX ,

here is my requirement .

i have to retrieve bunch of values from Database . this operation happens several times during transformation , is it possible that TX can keep the retreived data in cache memory , and next time when again call is made it gets from the cache rather from the database.

do we need to do any configuratin settings for this to happen.

would be great if you can provide me a solution for this
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: muralee

can anybody please provide solution for the above question.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Try modifying the input card settings to:
SourceRule-->FetchAs-->WorkArea: Reuse

Read the help screen by pressing F1 and then click-on the link, "Guidelines for Reusing Work Areas"

Jim Divoky
EC Solutions, Inc.
330-606-6826
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange