This procedure shows how to set up the metadata of the reference file
directors.txt in the Repository.
This metadata item will be used to add and set up the lookup input in this scenario.
Procedure
-
In the Repository tree view, expand the
Metadata node, right-click
File delimited, and select
Create file delimited from
the contextual menu to open the New Delimited
File wizard.
-
Enter a name for the file connection,
directors in this example,
and other useful information to better describe your file
metadata, and then click Next to go
to the next step and define the general properties of the
file.
-
In the File field specify the path of
the source file, or click Browse to
browse to the file.
The file is loaded, and the File
Viewer area displays an abstract of the
file, allowing you to check the file consistency,
the presence of header and more generally the file
structure.
-
Select Windows from the
Format list, and click
Next to parse the file.
-
From the Field Separator list of the
File Settings area, select
Comma.
-
Click Next to retrieve the file
schema.
The Description of the Schema table
displays the generated file schema.
-
Name the schema directors_schema and
rename the columns to directorID and
directorName respectively,
and change the data type of the
directorID columns from
Integer to String.
-
Click Finish to validate the schema
close the wizard.
The created file metadata is shown in the
Repository tree view.
Results
You now have the directors file metadata ready for use when
you set up the component to read the reference file.