Have you thought about using the Atrium Integration Engine for this? We are doing pretty much the same thing. The AIE gives several options for creating and updating records.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Weise Sent: Thursday, March 27, 2008 12:38 PM To: [email protected] Subject: Verify records prior to import of people We are running AR System 7.01 connecting to an Oracle 10g database. We are maintaining our people by importing the records from a view against our Lawson HR data. We take this and populate a staging table and then run Active links to look for and populate any changes to the people records. We repopulate the staging table with fresh data nightly. I want to verify there are records in the Lawson view before clearing the staging table. Any ideas what I could do to accomplish this? ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
