Creation of Target Defenition

The source definition can be created using source analyzer tool in the designer client component.

• From data base the source analyzer can get the structure of the data

• Open the client designer

        Note:

        At a time only one folder can be active and the bold representation indicates that             the folder is in active state.

• The subfolder source contains source definition and targets contain target definition.

• The sub folders cannot be created for that they are created automatically

• The right hand side window is called the work space.

• The left window is the repository navigator.

 PROCEDURE:

• Open the client source designer

• From repository navigator window connect to the repository with the name <Rep_name>

• Select the folder (dwh)

• From tools menu select source analyzer

• From source menu

• Click on import from database

• Connect to the database with the following data

        1. ODBC data source    : dwh-source-oracle

        2. Username                : Scott

        3. Owner name            : Scott

        4. Password                 : tiger

• Click on connect

• Select the tables and click ok

• From repository Manu click an’ save’