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 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