Results

You run the entire process for all the supplier file by running the 01_process_all_suppliers transformation, which calls the 02_process_supplier transformation for each supplier input file. The 02_process_supplier transformation then calls the template 03_process_supplier_file transformation through the ETL metadata injection step.

Perform the following steps to run this example:

1. In PDI, open the 01_process_all_suppliers.ktr file found in the metadata-injection-example/transformation folder.

2. Run the 01_process_all_suppliers transformation.

3. Examine the processed_data_{today’s date}.txt file in the metadata-injection-example/data/out folder and the log_{timestamp}.txt file in the metadata-injection-example/logging folder.

These transformations create a single source text output file in the metadata-injection-example/data/out folder. The logs generated by the 01_process_all_suppliers transformation are in the metadata-injection-example/logging folder.

The output text file contains values from the input files for the following common values:

• Transaction date

• Transaction invoice number

• Net value of the transaction

• Currency used in the transaction