You can use a lookup view to validate data in a target table. The lookup view includes fields from the source table and lookup table. You join the tables based on fields in the tables or expressions. Data Validation Option precedes the source table field names with "S_." The lookup view stores the primary key of the lookup table as a foreign key.
in the Navigator and select
Add Lookup View
Lookup View Editor
dialog box opens.
Select the source table, lookup table, and their connections.
Select the lookup field to look up in the lookup table. You can use an expression for join fields in a lookup view.
Enter the description for the lookup view.
Create the source-to-lookup relationship.
to create an expression for the source or lookup field. If you enter an expression, you must specify the datatype, precision, and scale of the result. The datatype, precision, and scale of the source and lookup fields must be compatible. Use the PowerCenter expression syntax in the source field. Use database-specific SQL in the lookup field. You can validate the PowerCenter expression syntax.
to delete the selected source-to-lookup relationship.