Disconnected Lookups

Parent Previous Next


Disconnected Lookups


Disconnected lookups allow you to use a cache to perform lookups without an Advanced Lookup Cache Transform in your data flow.


Functions

There are two functions that can be used to execute disconnected lookups:


  LookupData(connectionManager As AdvancedLookupCacheConnectionManager, ParamArray args As Object) - Used to retrieve the FIRST column setup as an output column in the Advanced Lookup Cache Manager defined in the connectionManager parameter.

o   Parameters:

  connectionManager - The name of the Advanced Lookup Cache Connection Manager.

  args - Parameter array of input parameters defined in the Advanced Lookup Cache Connection Manager. Args will match the number of input parameters setup in the Advanced Lookup Cache Connection manager defined in the connectionManager argument.

 LookupDataByColumn(connectionManager As AdvancedLookupCacheConnectionManager, outputColumnName As String, ParamArray args As Object - Used to retrieve the value of the column defined in the outputColumnName parameter from the Advanced Lookup Cache Connection manager defined in the connectionManager parameter.

oParameters:

connectionManager - The name of the Advanced Lookup Cache Connection Manager

outputColumnName - The name of the column to retrieve from the output. The column defined here must be setup as an output column in the Advanced Lookup Cache Connection Manager.

args - Parameter array of input parameters defined in the Advanced Lookup Cache Connection Manager". Args will match the number of input parameters setup in the Advanced Lookup Cache Manager defined in the connectionManager argument.