Last updated on FEBRUARY 16, 2016
Applies to:Siebel Sales - Version 22.214.171.124  and later
Information in this document applies to any platform.
Qn1: On : 126.96.36.199  version, EIM
The requirement is to export data from a Siebel base table to an external schema, using a daily EIM export.
Is there any possibility to do a partial load to EIM table?
On the first day, 100 records are loaded to the EIM table; after moving that data to the external schema the records are not deleted in the EIM table.
In the next day load, only the changed / newly created records (if any) shall be pushed to the EIM table - not all the records. Say 2 records have been updated and 1 has been created, then only these 3 changes need to be pushed to EIM.
In EIM on the total records will be: 2 updated + 1 newly created + 97 unmodified record = 100
Qn2: How do we identify the changed records in the base table and push that in EIM?
Qn3: If the records changed in the base table and now I'm using a new batch number to export the data to EIM table, this will be created as a new record in EIM but in this case if I want to overwrite the exiting record in EIM with the new changed values is it possible?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms