In TIBCO Scribe® Online, the CSVLOOKUPVALUE function used with a CSV file, can improve overall Map performance. Internal benchmark trials have shown performance improvements of 70% or more when using this function, versus using either a Lookup Block operation or the LOOKUPTARGETVALUE function to acquire specific endpoint data. 

The CSVLOOKUPVALUE function provides the following advantages:

• You can dynamically keep the CSV file up-to-date because it can be recurrently modified by a TIBCO Scribe® Online Map.
• Because the CSV file is reserved within an On-Premise Agent's memory, the function performs at a higher level.

Although the initial setup of the CSV file requires time, when it is set up, the performance benefits of using this function are quickly and continually realized. When you must integrate a data source that includes a large record count into a target system, this function provides significant integration performance improvements.

In Scribe Online, the CSVLOOKUPVALUE function can improve your overall map performance, instead of using a Lookup block operation or the LOOKUPTARGETVALUE function to acquire specific endpoint data.