You add a reference table to a transformation in the Developer tool. You configure the transformation to find reference table values in input data and to write the corresponding valid values from the reference table as output.
To create a reference table in the Developer tool, use one of the following methods:
Create an empty reference table and enter the data values.
Create a reference table from data in a flat file.
Create a reference table from data in a database table, synonym, or view.