Working with Sources - the Create option

Apart from importing the file or table structure, we can manually create the Source Definition. When the sample source file or the table structure is not available, we need to manually create the source structure. When we select the create option, we need to define every details related to the file or table manually, such as the name of the source, type of source, 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.

Following are the steps that you will have to perform to create option.

  1. In the Designer, go to Tools | Source Analyzer to open the Source Analyzer.
  2. Go to Sources |

Get Learning Informatica PowerCenter 10.x - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.