This procedure shows how to set up the metadata of the reference file directors.txtdirectors.txt in the Repository. This metadata item will be used to add and set up the lookup input in this scenario.
Before you begin
-
You have the file directors.txt ready in the directory C:\getting_started\input_data\.
Procedure
-
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.
-
From the Field Separator list of the
File Settings area, select
Comma.
-
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.