Follow these steps to provide information
about the data's content.
-
Click the Content tab. Use the fields under the
Content tab to define how your data is
formatted.
-
Verify that the Separator is set to comma (,) and that
the Enclosure is set to quotation mark ("). Select
Header and enter 1 in the
Number of header lines field.
-
Click the Fields tab and click Get
Fields to retrieve the input fields from your source file. When
the Number of lines to sample window appears,
enter 0 in the field, then click
OK.
-
If the Scan Result window displays, click
Close to close the window.
-
To verify that the data is read correctly, click the
Content tab, then click Preview
Rows.
-
In the Enter the number of rows you would like to
preview window, click OK to accept the
default.
The Examine preview data window
appears.
-
Review the data. Do you notice any missing, incomplete, or variations of the
data?
- STATE & POSTALCODE both contain
<null>
- COUNTRY contains both USA
and United States.
-
Click OK to save the information that you entered in the
step.
-
Enter a name for the transformation and provide additional properties using the
Transformation Properties window. There
are multiple ways to open the Transformation
Properties window.
- Right-click on any empty space on the canvas and select
Properties.
- Double-click on any empty space on the canvas to select
Properties.
- Enter the CTRL-T keyboard
combination.
-
In the Transformation Name field, enter
Getting Started Transformation.
Below the name, the filename is empty.
-
Click OK to close the Transformation
Properties window.
-
To save the transformation, select .
When saving your transformation for the first time, you are prompted for a
file location and name of your choice. The file extension
.ktr is the usual file extension for
transformations.