You might need to shorten the view column name if the length causes a database error when PowerCenter processes a test based on the join view. By default, Data Validation Option appends the table name to the table column name to generate the view column name.
You might change the name of the view column to make the column name more descriptive. Or, to automatically generate table-pair tests based on matching column names, you can use a column alias to ensure that the column names in both tables match.
If applicable, you must override the column alias before you create an expression for the join condition. Data Validation Option processes the join condition using the column aliases. If you create the join condition expression based on the original column names and then override the column aliases, an error occurs.