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.