Reference files

Change Files can either reside in a single location or in multiple locations. To access Change Files that reside in different locations and/or that do not include the target table names, you need to use a Reference File. If the rows in the Change File(s) contain the names of the tables to which to apply the changes, then the Reference File only needs to contain the paths to the Change Files. If each Change File contains changes for a single table, then each of the Change File paths in the Reference File needs to be preceded by the name of its corresponding target table.

For more information on Reference File and Reference File formats, see Change Processing.

Each row in the Reference File should be formatted as follows:

[<table_name>],<full path to Change File>

Where [<table_name>] is required only if the referenced Change File contains changes for a single table.

Reference File: Each Change File contains changes for a single table:

table1,c:\temp\cdc1.csv

table2,c:\temp\cdc2.csv

table3,c:\temp\cdc3.csv

Reference File: Each Change File contains changes for multiple tables:

c:\temp\cdc1.csv

c:\temp\cdc2.csv

c:\temp\cdc3.csv