Lesson Two, Source , Target Definitions and Target Tables

Creating Source Definitions:
In Source Analyzer, to create a source definition you have to have a source--Database , Flat File or XML.... So you can Import from source and edit it, but seems you can't create by your own. For edit, you can add , delete and update columns, and add some meta data to each table definition.

Creating Target Definitions:
In Target Designer, to create a target definition, you can drag and drop from source definitions table list or create table by your self. Nothing special just like create a normal table. But remember select correct database type.

Creating Target Tables:
In target Designer, you can create table in database and informatica SQL statement from your target table definitions.

Click Targets > Generate/Execute SQL.
In the File Name field, enter the SQL DDL file name.
Select the Create Table, Drop Table, Foreign Key and Primary Key options.
Click the Generate and Execute button.

So from what I did and see , it's simple to create source and target definition. Just like create new tables in database. One thing I don't like, after important source definition from database. The layout view is not well arranged like other database logic view. you have to rearrange them by yourself. So many software can do this job automatically, I don't know why PowerCenter Designer can't do this.