Advanced-etl-processor
Range Lookup
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | Performing range lookups (or finding a key for a given range) is a common ETL operation in data warehousing scenarios. It’s especially useful for historical loads and late arriving fact situations, where you’re using type 2 dimensions and you need to locate the key which represents the dimension value for a given point in time. |
| Properties |
Data for lookup can be entered manually or loaded from the database or a file.
To change Transformation function properties double click on it
Video Tutorial
Back to Working with Transformer
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum