Hi, So we have this Delta view on our HR Oracle db. The 'change column' reflects add, delete, modify as per http://www.wapshere.com/missmiis/configuration-of-the-sql-ma. what we would like to know is this: does FIM automatically update this 'change column' so that we do not rerun the same delta imports everytime the Delta Import Profile is executed? How does FIM notify Oracle that it has processed the changes in the delta View? thank you.

you need to clear the oracle delta table (which the delta view is configured to read from) after the sync cycle is finished, you can create simple script (vbs) to clear the table ... also you need to implement a flag "onhold" and you should set that flag before importing, you should configure your view to read only from the users with "onhold" flag is true. by doing that when clearing the delta table you clear only the onhold rows, since changes might be inserted into your delta table while the sync script is running.

So FIM does nothing by itself to help here I see, great. 1. You mention a flag 'on hold' where and what is this? Is this somthing in the Oracle table? In FIM??? 2. this 'simple clear script' you mention...is that a script that must be executed from Oracle? or from FIM? How do we know when to actually execute the script? what starts the script?

the flag column should be in the delta table {userid,operation,flag}, your DB view should be configured to get the rows with flag is set to 1. the view should be something like this: select f.* from full_table f,delta_table d where f.userid=d.userid and d.flag=1 since FIM server already has oracle client installed and configured the script can be executed from the FIM server, actually you'll need two scripts: 1. one to set the flag to "1" for all the current rows in the delta table (by default when changes are populated in the delta table the flag should be set as "0") this script must be called prior to starting the sync script ( if you already automated the run profiles) 2. a script to clear the rows within the delta table with flag is "1" delete from table_name where flag=1 this script must be called after the sync script is finished

Could you please point me to where this information may be documented by Microsoft, is this anywhere in the MIIS/ILM/FIM documentation?

I done that in the past when it was ILM 2007, we were running database triggers to fill delta table with the corresponding operation. in MIIS 2003 documentation: http://technet.microsoft.com/en-us/library/cc708665%28WS.10%29.aspx we added the flag to solve the problem that changes might be populated while the sync cycle is running

thanks for your prompt feedback, highly appreciated.