ETLLookup class
ETL family — class
ETL Lookup component that enriches data by joining with reference data. Displays as a cylinder with two inputs (main data + reference data). Supports caching strategies for performance optimization.
Members
| Member | Kind | Description |
|---|---|---|
CacheMode CacheMode | Property | Cache strategy: None, Partial, Full |
string MatchColumns | Property | Columns to match (CSV: MainCol=RefCol,...) |
string ReturnColumns | Property | Columns to return from reference (CSV) |
bool FailOnNoMatch | Property | Fail if lookup finds no match |
string OutputSchema | Property | Output schema (JSON array of ColumnDefinition) |
ETLLookup() | Method | Initializes a new instance of the ETLLookup class. |