Learning Informatica PowerCenter 10.x - Second Edition

Working with Target - the Create option

Apart from importing the file or table structure, we can manually create the Target Definition. When the sample Target file or the table structure is not available, we need to manually create the Target structure. When we select the create option, we need to define every detail related to the file or table manually, such as the name of the Target, the type of the Target, column names, column data type, column data size, indexes, constraints, and so on. When you import the structure, the import wizard automatically imports all these details.

1. In the Designer, go to Tools | Target Designer to open the Target Designer.
2. Go to Target | Create.
3. Select the type of Target you wish to create from the drop-down ...