Working with Target relational database tables - the Import option

Just as we discussed importing and creating source files and source tables, we need to work on target definitions.

The process of importing the target table is exactly same as importing the Source table, the only difference is that you need to work in the Target Designer.

You can import or create the table structure in the Target Designer. After you add these target definitions to the repository, you can use them in a mapping.

Follow these steps to import the table target definition:

1. In the Designer, go to Tools | Target Designer to open the Target Designer.
2. Go to Targets | Importfrom Database.
3. From the ODBC data source button, select the ODBC data source that you created to access source tables. We have already added the data source while working on the sources.
4. Enter the username and password to connect to the database.
5. Click on Connect.
6. In the Select tables list, expand the database owner and the TABLE heading.
7. Select the tables you wish to import, and click on OK.

The structure of the selected tables will appear in the Target Designer in workspace.

As mentioned, the process is the same as importing the source in the Source Analyzer. Follow the preceding steps in case of some issues.