Creation of Source 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 sub-folder 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 MEnu click an’ save’