I have a FMPA 11 db with several tables that mirror their counterparts in an Oracle enterprise data warehouse. I am using FMPA as a simpler, more efficient method to view, insert, append, and delete Oracle records (over which I have those privileges) than writing lengthy, detailed SQL queries against Oracle. When I use Manage>Database>Sync, what are the sync limitations? I.e.:
If I have setup unique identifiers, does Sync setup need to be repeated with each sync, or does one setup allow unlimited syncs on the same relationship?
How long should a modification in FM take to propagate to Oracle after a sync?
Is this a safe and reliable method to append existing records?
I have the experience that the Oracle side tends to repopulate FM after a sync if I have deleted FM records. Am I doing something wrong that can be corrected?