Range Lookup

CategoryTransformation Function
DescriptionPerforming 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.
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

  • aetle/transformation_functions/lookups/range_lookup.txt
  • Last modified: 01/08/2022 14:19
  • by admin