Configure your Lookup Manager to use data from CSV files
An easy way to initialize a Lookup Manager application is by using CSV files to initialize the enrichment data. You generate the content of such files in many different ways, for example by using a spreadsheet application, or by exporting a database table in CSV format or as a DEL file. You store the complete contents of the CSV files, or you can use the needed columns in the lookup repository to access data faster during production data file processing.
For this use case, the generated SPL source code does not contain database code. The application control provides command requests directly to the command splitter composite. The following figure shows the process flow for this specific use case:
About this task
Configure the Lookup Manager application to use CSV files as input for the initialization.
Procedure
- In the file <PathToYourApplication>/config/config.cfg, find the lm.file parameter
-
Enable CSV file input by setting the parameter to on as follows: lm.file=on
-
In the file <PathToYourApplication>/config/config.cfg, find the lm.db parameter
-
Disable database input by setting the parameter to off as follows: lm.db=off
-
Open the <PathToYourApplication>/LookupMgrCustomizing.xml configuration file for editing
-
Define the unique DataSource elements necessary for your solution
-
Define the repository segment by using the Name attribute. Choose the same name for the CSV input file as the Name, for example DimMaster1.csv for init and update commands and DimMaster1.del.csv for the delete command.
-
Use the IndexInInputFile attribute that is required when you use the CSV file as data source to define the column index. The order is not relevant. The combination of the Name and IndexInInputFile attributes is important. The index is zero-based.
-
When you finished adapting the configuration files, compile your Lookup Manager to create an application that uses CSV files as input data
