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\.
- 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
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
Click Next to retrieve the file
The Description of the Schema table displays the generated file schema.
Name the schema directors_schema and
rename the columns to directorID and
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.
You now have the directors file metadata ready for use when you set up the component to read the reference file.