Some Useful Articles
1. How can data from a base table be deleted, while leaving rows that were not fully imported earlier for further examination and correction?
2. Handling Data Dependencies in EIM using IFB Files
3. Using Error and Trace Flags in EIM Error handling
4. How to Resolve Siebel EIM Errors?
5. Creating Siebel ROW_ID through EIM
6. How to Populate User Keys and Required Columns using Siebel EIM?
7. Is it Possible to Update the User Key using EIM?
8. Handling Siebel Base Tables with no user keys during EIM
9. Choosing the correct interface table for Siebel EIM process
10. Siebel EIM Import Order of Entities
11. Component request parameters for running an EIM process
12. Running the Siebel EIM Process
13. Mystery of Siebel EIM Merge Process Explained
14. Siebel EIM Delete Process Parameter Reference
15. Siebel EIM Export Parameter Process Reference
16. Reference to Siebel EIM Import Parameters
17. What is IFB file?
18. How is IFB File Structured?
19. Update user key Column for Product Entity, through EIM
20. EIM Data Loading : Oracle function - Bulk Collect
21. EIM Tuning - Reference
22. EIM Tuning to improve performance
23. EIM Data Cleansing : Oracle function – Regular Expression
24. Table Lock in Oracle
25. EIM Column Extension in Siebel 8.x
26. Table Fragmentation and Siebel EIM
27. Purging an EIM table
28. Caching tables for EIM
29. What is FREELIST Parameter?
30. Handling EIM Failures after Siebel Upgrade
31. Siebel EIM Batch Size could have an adverse impact on Siebel Remote and Replication Manager Environments
32. EIM Merge and Delete processes should use only one commit per batch to avoid data integrity issues
33. EIM EXPORT / DELETE functionality for S_PARTY siebel base tables
34. What is the recommended number of rows that can be loaded in a single batch?
35. How can I tune my EIM batches to improve performance?
36. How do I use the DELETE EXACT parameter to delete data from base tables other than the target base table?
37. How do I populate the PR_PROD_LN_ID column in the S_PROD_INT base table?
38. Does EIM support importing multiple addresses for accounts?
39. We successfully imported most of our interface table rows and want to delete them. However, we want to leave rows that were not fully imported so that we can examine and correct them. How can we do this?
40. Does EIM evaluate properties on Business Component (BC) level (such as default value or LOV type)?
41. Will EIM interfere or affect Visual Basic code built into the application?
42. Does EIM support importing data from ACT?
43. What columns in each interface table are mandatory in order for a row to be loaded? What must their values be? Which columns (such as foreign keys) are validated against other tables?
44. Does EIM support case values?
45. How should users relate two PARTY Objects (example: Accounts and Contacts) in Siebel when importing data using Enterprise Integration Manager?
46. What should be done when Enterprise Integration Manager fails with message “This is a foreign key value in the base table and the values in the interface table did not resolve to existing values”?
47. Why do users need to populate PARTY_UID in the S_PARTY base table while using Enterprise Integration Manager?
48. What is the difference between the S_REVN table and the S_OPTY_POSTN table?
49. How can users define multiple Extended Parameters values when running Enterprise Integration Manager (EIM) from the command prompt in a batch file?
50. How are addresses for account stored in the vertical Siebel 7 – Industry Application?
51. How to use MISC SQL in Siebel to set the primary foreign keys in the EIM Step 11?
52. How should users run the EIM Table Mapping Wizard in Siebel Tools?
53. How can users find differences in all interface tables between two repositories?
54. How are index hints used in an EIM process?
55. How should EXPORT MATCHES and DELETE MATCHES be used in Siebel?
56. How can users generate an Enterprise Integration Manager Log file in Siebel?
57. Why are imported accounts not visible in Siebel 7 after the successful import using Enterprise Integration Manager?
58. Why is the Primary ID not populated during an EIM task even though the corresponding EIM mapping columns are appropriately populated in the Interface table?
59. What values must be populated for PARTY_TYPE_CD, PARTY_UID and ROOT_PARTY_FLG columns in S_PARTY table using EIM?
60. How are CREATED and CREATED_BY columns populated using EIM?
61. How can users determine if there is an interface mapping to a particular table or column and which interface tables or columns can be used for importing to this base table or base column?
62. Can the PRIV_FLG column of S_CONTACT base table be updated using EIM (Private_Flag is used to enforce Personal Contacts)?
63. Why does the Interface Manager continue processing even when multiple rows fail a pass?
64. Is it possible to delete or merge records through Interface Manager that have the same user primary key and different conflict IDs?
65. How can I tune my EIM batches to improve performance?
66. How to import data to a LOV Type column?
67. What are the various Enterprise Integration Manager Interface Table Keys and do they need to be populated?
68. Why is the SQL not traced in the EIM tasks log file despite setting SQL Trace Flags to 8?
69. How can file attachments be imported via EIM?
2. Handling Data Dependencies in EIM using IFB Files
3. Using Error and Trace Flags in EIM Error handling
4. How to Resolve Siebel EIM Errors?
5. Creating Siebel ROW_ID through EIM
6. How to Populate User Keys and Required Columns using Siebel EIM?
7. Is it Possible to Update the User Key using EIM?
8. Handling Siebel Base Tables with no user keys during EIM
9. Choosing the correct interface table for Siebel EIM process
10. Siebel EIM Import Order of Entities
11. Component request parameters for running an EIM process
12. Running the Siebel EIM Process
13. Mystery of Siebel EIM Merge Process Explained
14. Siebel EIM Delete Process Parameter Reference
15. Siebel EIM Export Parameter Process Reference
16. Reference to Siebel EIM Import Parameters
17. What is IFB file?
18. How is IFB File Structured?
19. Update user key Column for Product Entity, through EIM
20. EIM Data Loading : Oracle function - Bulk Collect
21. EIM Tuning - Reference
22. EIM Tuning to improve performance
23. EIM Data Cleansing : Oracle function – Regular Expression
24. Table Lock in Oracle
25. EIM Column Extension in Siebel 8.x
26. Table Fragmentation and Siebel EIM
27. Purging an EIM table
28. Caching tables for EIM
29. What is FREELIST Parameter?
30. Handling EIM Failures after Siebel Upgrade
31. Siebel EIM Batch Size could have an adverse impact on Siebel Remote and Replication Manager Environments
32. EIM Merge and Delete processes should use only one commit per batch to avoid data integrity issues
33. EIM EXPORT / DELETE functionality for S_PARTY siebel base tables
34. What is the recommended number of rows that can be loaded in a single batch?
35. How can I tune my EIM batches to improve performance?
36. How do I use the DELETE EXACT parameter to delete data from base tables other than the target base table?
37. How do I populate the PR_PROD_LN_ID column in the S_PROD_INT base table?
38. Does EIM support importing multiple addresses for accounts?
39. We successfully imported most of our interface table rows and want to delete them. However, we want to leave rows that were not fully imported so that we can examine and correct them. How can we do this?
40. Does EIM evaluate properties on Business Component (BC) level (such as default value or LOV type)?
41. Will EIM interfere or affect Visual Basic code built into the application?
42. Does EIM support importing data from ACT?
43. What columns in each interface table are mandatory in order for a row to be loaded? What must their values be? Which columns (such as foreign keys) are validated against other tables?
44. Does EIM support case values?
45. How should users relate two PARTY Objects (example: Accounts and Contacts) in Siebel when importing data using Enterprise Integration Manager?
46. What should be done when Enterprise Integration Manager fails with message “This is a foreign key value in the base table and the values in the interface table did not resolve to existing values”?
47. Why do users need to populate PARTY_UID in the S_PARTY base table while using Enterprise Integration Manager?
48. What is the difference between the S_REVN table and the S_OPTY_POSTN table?
49. How can users define multiple Extended Parameters values when running Enterprise Integration Manager (EIM) from the command prompt in a batch file?
50. How are addresses for account stored in the vertical Siebel 7 – Industry Application?
51. How to use MISC SQL in Siebel to set the primary foreign keys in the EIM Step 11?
52. How should users run the EIM Table Mapping Wizard in Siebel Tools?
53. How can users find differences in all interface tables between two repositories?
54. How are index hints used in an EIM process?
55. How should EXPORT MATCHES and DELETE MATCHES be used in Siebel?
56. How can users generate an Enterprise Integration Manager Log file in Siebel?
57. Why are imported accounts not visible in Siebel 7 after the successful import using Enterprise Integration Manager?
58. Why is the Primary ID not populated during an EIM task even though the corresponding EIM mapping columns are appropriately populated in the Interface table?
59. What values must be populated for PARTY_TYPE_CD, PARTY_UID and ROOT_PARTY_FLG columns in S_PARTY table using EIM?
60. How are CREATED and CREATED_BY columns populated using EIM?
61. How can users determine if there is an interface mapping to a particular table or column and which interface tables or columns can be used for importing to this base table or base column?
62. Can the PRIV_FLG column of S_CONTACT base table be updated using EIM (Private_Flag is used to enforce Personal Contacts)?
63. Why does the Interface Manager continue processing even when multiple rows fail a pass?
64. Is it possible to delete or merge records through Interface Manager that have the same user primary key and different conflict IDs?
65. How can I tune my EIM batches to improve performance?
66. How to import data to a LOV Type column?
67. What are the various Enterprise Integration Manager Interface Table Keys and do they need to be populated?
68. Why is the SQL not traced in the EIM tasks log file despite setting SQL Trace Flags to 8?
69. How can file attachments be imported via EIM?