EIM FAQ
1. What is Siebel EIM?
2. Why do we use EIM instead of direct SQL updates and inserts in base tables?
3. Why does Oracle does not recommend using native SQL to perform different operations on base tables?
4. What are the different EIM functions?
5. What is IFB file?
6. Where does the IFB file reside on server?
7. What are the mandatory EIM columns that needs to be populated in different EIM processess?
8. Why does EIM uses temporary columns? Give an example.
9. What is difference between CON_BU and CON_BI columns of EIM_CONTACT table?
10. How can you identify which siebel base tables can be populated by an EIM table in Siebel tools?
11. How can you identify which EIM tables can populate a Siebel base table in Siebel tools?
12. What do you mean by non-target base tables?
13. How can you manually create EIM column for a newly created base table column? (Tricky)
14. How do you run EIM table mapping wizard in Siebel tools?
15. What are (Primaries) Primary Foriegn Keys? What is the use of primaries (Primary Foriegn Keys) in Siebel data model?
16. Explicit primary mapping does not occur in each EIM table mapping. In which case can you find the explicit primary mapping defined in the EIM table mapping?
17. How will you identify the corresponding EIM column for a particular base table column? Say for S_PROD_INT.NAME, explain.
18. What is the difference between IF_ROW_STAT and IF_ROW_STAT_NUM columns?
19. Name few header parameters in EIM configuraion file generic for all EIM processess.
20. Which parameter should be the first non-commented line in the ifb file?
21. In the ifb file, you have mentioned the credentials for database incorrectly but the proper credentials are stored at srvmgr level, will the job throw any error?
22. Name few process parameters in EIM configuraion file generic for all EIM processess.
23. What does INCLUDE parameter mean in an ifb file?
24. In which EIM process ROLLBACK ON ERROR = TRUE parameter in the ifb file is highly recommended?
25. What is the purpose of SESSION SQL parameter in the ifb file?
26. Why USING SYNONYMS = FALSE parameter is highly recommended for EIM performance tuning?
27. What is the difference between DEFAULT COLUMN and FIXED COLUMN parameters?
28. What are the required process parameters in the ifb file?
29. Can you enumerate the 11 steps for EIM import process?
30. Which record will be processed for two duplicate records in the EIM table?
31. If I update the IF_ROW_STAT column as 'IMPORTED' for a batch of records and run the job, will it run successfully?
32. What are the different IF_ROW_STAT values possible after EIM job is run for Import process?
33. When we should ONLY BASE COLUMNS and IGNORE BASE COLUMNS parameters?
34. What is the use of MISC SQL parameter? Explain with example.
35. What is the use of NET CHANGE parameter? Explain with example.
36. Is it possible to update user key column with NULL using the NET CHANGE parameter?
37. How can you update base columns with null value through EIM?
38. How can you supress insert in the base table through ifb file?
39. How do you update denormalized columns through EIM?
40. Can you update records in S_PARTY table through EIM?
41. What are the required columns that have to be populated while updating S_PARTY records?
42. If PARTY_TYPE_CD column is 'Organization' or 'Position', which other column needs to be populated?
43. While importing Employees and Positions, which entity would you import first?
44. What is the difference between "DUP_RECORD_EXISTS" and "DUP_RECORD_IN_EIM_TBL" IF_ROW_STAT values?
45. What does "PARTIALLY_IMPORTED" in IF_ROW_STAT column mean?
46. When do you get "PICKLIST_VALUE" error in IF_ROW_STAT column?
47. What is EXPORT ALL ROWS and EXPORT MATCHES parameter in export process?
48. Which table's (Base or EIM) column is used in the WHERE clause of the EXPORT MATCHES parameter?
------------------------MORE TO COME------------------------------
2. Why do we use EIM instead of direct SQL updates and inserts in base tables?
3. Why does Oracle does not recommend using native SQL to perform different operations on base tables?
4. What are the different EIM functions?
5. What is IFB file?
6. Where does the IFB file reside on server?
7. What are the mandatory EIM columns that needs to be populated in different EIM processess?
8. Why does EIM uses temporary columns? Give an example.
9. What is difference between CON_BU and CON_BI columns of EIM_CONTACT table?
10. How can you identify which siebel base tables can be populated by an EIM table in Siebel tools?
11. How can you identify which EIM tables can populate a Siebel base table in Siebel tools?
12. What do you mean by non-target base tables?
13. How can you manually create EIM column for a newly created base table column? (Tricky)
14. How do you run EIM table mapping wizard in Siebel tools?
15. What are (Primaries) Primary Foriegn Keys? What is the use of primaries (Primary Foriegn Keys) in Siebel data model?
16. Explicit primary mapping does not occur in each EIM table mapping. In which case can you find the explicit primary mapping defined in the EIM table mapping?
17. How will you identify the corresponding EIM column for a particular base table column? Say for S_PROD_INT.NAME, explain.
18. What is the difference between IF_ROW_STAT and IF_ROW_STAT_NUM columns?
19. Name few header parameters in EIM configuraion file generic for all EIM processess.
20. Which parameter should be the first non-commented line in the ifb file?
21. In the ifb file, you have mentioned the credentials for database incorrectly but the proper credentials are stored at srvmgr level, will the job throw any error?
22. Name few process parameters in EIM configuraion file generic for all EIM processess.
23. What does INCLUDE parameter mean in an ifb file?
24. In which EIM process ROLLBACK ON ERROR = TRUE parameter in the ifb file is highly recommended?
25. What is the purpose of SESSION SQL parameter in the ifb file?
26. Why USING SYNONYMS = FALSE parameter is highly recommended for EIM performance tuning?
27. What is the difference between DEFAULT COLUMN and FIXED COLUMN parameters?
28. What are the required process parameters in the ifb file?
29. Can you enumerate the 11 steps for EIM import process?
30. Which record will be processed for two duplicate records in the EIM table?
31. If I update the IF_ROW_STAT column as 'IMPORTED' for a batch of records and run the job, will it run successfully?
32. What are the different IF_ROW_STAT values possible after EIM job is run for Import process?
33. When we should ONLY BASE COLUMNS and IGNORE BASE COLUMNS parameters?
34. What is the use of MISC SQL parameter? Explain with example.
35. What is the use of NET CHANGE parameter? Explain with example.
36. Is it possible to update user key column with NULL using the NET CHANGE parameter?
37. How can you update base columns with null value through EIM?
38. How can you supress insert in the base table through ifb file?
39. How do you update denormalized columns through EIM?
40. Can you update records in S_PARTY table through EIM?
41. What are the required columns that have to be populated while updating S_PARTY records?
42. If PARTY_TYPE_CD column is 'Organization' or 'Position', which other column needs to be populated?
43. While importing Employees and Positions, which entity would you import first?
44. What is the difference between "DUP_RECORD_EXISTS" and "DUP_RECORD_IN_EIM_TBL" IF_ROW_STAT values?
45. What does "PARTIALLY_IMPORTED" in IF_ROW_STAT column mean?
46. When do you get "PICKLIST_VALUE" error in IF_ROW_STAT column?
47. What is EXPORT ALL ROWS and EXPORT MATCHES parameter in export process?
48. Which table's (Base or EIM) column is used in the WHERE clause of the EXPORT MATCHES parameter?
------------------------MORE TO COME------------------------------