With a hash index you can find a record in a given file in constant time by generating a hash value for the record and then looking up the record in the file based on that hash value.

In the previous examples, the first column (i.e., the top manager) was specified as constant value.

An assign parameter mapping lets you specify a constant value to put in a target parameter.