Originally posted by: Kiran Kumar Reddy

Hello,

In one of my functional map I am doing a DBLOOKUP to get a particular value based on a fields data (which has duplicates).

Ex: If my field with which I do the lookup has the following values
1
1
1
1
2
1
2
1

Here the value 1 appears multiple times.
Instead of executing the DBLOOKUP function for every value of 1 (6 times), Is there a way I can avoid executing the same DBLOOKUP multipe times for the value 1?

Thanks,
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: NancyR

I think the approach I sent will still work.

Once you run the map that strips off the last three characters, you may also need to remove the trailing spaces from the 10 characters in the CSV record. If you then use the RUN function to send that file to the second map, it should work.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: thorstenhirsch

If the table is not too big, you can use an input card to read the whole table and then LOOKUP in the input card. So you wouldn't cache the results, but you would cache the input data locally.

However, this approach might result in a slower map, because WTX's LOOKUP is very slow. Instead, you should sort the table while reading (use a query on the input card that ends with "order by field1") and use SEARCHUP in your map. That's very fast.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

once your ip is sorted as explained , you could also read that in chunks of the sorted field by doing a control break in TT to make it efficient & then use it.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

To resolve this issue:

1: use a rule similar to this =f_do_dblookup(UNIQUE(ListOfValues)
2: then in the functional map do your dblookup function.

sorry, if i misuderstand the issue. However this seems to be a simple solution.

hope this helps
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange