Skip to main content

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.

Information note

Reference File names cannot exceed 70 characters (no such limitation exists for the path length). Reference File names that exceed 70 characters will be ignored and appropriate warning will be written to the log.

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!