Range Lookup

Range Lookup transformation function

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.

Range Lookup transformation function

Range Lookup transformation function error handling

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
Last updated: August 1, 2022