The new release of the Advanced ETL Processor adds Range Lookup function to our vast library of data transformation functions.

Range Lookup

Performing range lookups (or finding a key for a given range) is a common ETL operation in data warehousing scenarios. It's especially 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

Range Lookup Properties

Direct link, no registration required.