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
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL forum