To provide Data Validation Option with the information it needs to create an SQL view, you must specify the tables that the SQL statement is based on and the corresponding database connection. When you provide the tables and connection information, Data Validation Option can access the metadata that is necessary for the view to function correctly.
To add a table, click
. The Choose Data Source dialog box opens. This dialog box displays all of the relational tables available in the repositories. You can sort information in this dialog box by clicking the column headers. You can reduce the number of items to select by typing one or more letters of the table, file, or view name in the
field. Select a table and click
. All of the tables you use in an SQL view must exist in the same database.
If you identify the table with an alias in the SQL statement you use to create the view, enter the alias name next to the table name.
When you finish adding tables, select the PowerCenter connection for the tables from the