|Bookshelf Home | Contents | Index | PDF|
This topic is part of Recommended Sequence for Implementing Siebel EIM Processes.
One method to find out if the .IFB file is optimized is to check the status of the records being processed in the EIM tables. This indicates if there are tables or columns that are being processed unnecessarily. The following query can be used to check the status of records in an EIM table:
If many rows have a status of PARTIALLY IMPORTED, then it is likely that further tuning can be done by excluding base tables and columns that are not necessary. For example, two tests were run to import 5000 accounts from the EIM_ACCOUNT table. The first test included all of the base tables while the second test only focused on the four necessary tables by including the following line in the .IFB file:
|Siebel Performance Tuning Guide||Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.|