Mapping date using an Alias table

This scenario describes a Job that maps information from two input tables and an alias table, serving as a virtual input table, to an output table. The employees table contains employees' IDs, their department numbers, their names, and the IDs of their respective managers. The managers are also considered as employees and hence included in the employees table. The dept table contains the department information. The alias table retrieves the names of the managers from the employees table.