Starting the Development Phase – Using the Designer Screen Basics - Learning Informatica PowerCenter 9.x - page 35

The structure of the selected tables will appear in the Target Designer screen in the work-
space.
As mentioned, the process is exactly similar to importing the source in Source Analyzer.
Please follow the preceding steps if you have any issues.
Working with target flat files - the Import option
The process of importing the target file is exactly the same as importing the source file;
the only difference is that you need to work in Target Designer.
Working with delimited files
Perform the following steps to import the delimited files:
1. In the Designer screen, navigate to Tools | Target Designer to open the Target
Designer.
2. Navigate to Targets | Import from file .
3. Browse the files you wish to import as source files.
4. The Flat File Import Wizard screen will pop up.
5. Select the file type: Delimited . Also select the appropriate option to import the
data from the row and import file names from the first line, as we did in case of
importing the source. Click on Next .
6. Select the type of delimiter used in the file. Also check the quotes option: No
quotes , Single quotes , and Double quotes —to work with the quotes in the text
values. Click on Next .
7. Verify the column name, data type, and precision in the data view option.
8. Click on Finish to get the target file imported in the Target Designer.
Working with fixed-width files
Perform the following steps to import the fixed width files:
1. In the Designer screen, navigate to Tools | Target Designer to open the Target
Designer.
2. Navigate to Targets | Import from file .
3. Browse the files you wish to use as source files.
4. The Flat File Import Wizard screen will pop up.
5. Select the file type: Fixed Width . Click on Next .
6. Set the width of each column as required by adding a line break. Click on Next .