Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >
Finding Differences in EIM Tables between Repositories
The Siebel Data Model changes from release to release, and EIM mappings change accordingly. You can use the UTLEIMDIFF utility to find EIM mapping differences between two repositories for a list of EIM tables that you input. The results can be used to help you update your EIM data loading scripts, programs, and so on.
- Create the view S_EIM_MAP_V in the database.
The database-platform-independent script for creating this view is called create_EIM_MAP_V.sql. This script can be found in the <dbsrvr>\common directory.
- Find the executable UTLEIMDIFF.EXE in the <tools>\bin directory. Use the following switches for the program:
The program may run for several minutes, depending on the number of tables to be compared.
- Interpret the three parts of the output file as follows:
- Part 1 - Interface Table Difference. Part 1 compares all the EIM tables in the two repositories.
- Part 2 - Interface Table Mapping Difference. Part 2 compares the EIM tables listed in the input file.
- Part 3 - Interface Column Mapping Difference. Part 3 compares the interface columns for the tables listed in the input file. "UK" means "User Key sequence." "Req'd" indicates that the column in the base table is required.
The first column of each part is the repository name. If there is an entry in one repository but not the other, then that means that the entry exists in one repository but not the other. If the same entry appears in both repositories, then that means that the entry has been modified.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |