Sorry i didnt answer your question fully. What is happening is that instead of updating the record in GOLD it is creating a new record. I never want to create a new record in Gold, i just want to update whats there, if it doesnt exist in Gold then i dont want to merge the record. If you said that it was a best practise to create a Staging dataset and merge to Gold how would this be possible as the staging dataset would always have a Recon ID? I really appreciate the help, Thanks, Sean
P Romain ARSlist wrote: > > When you say it doesn't work what exactly is happening, or not happening? > > If you are trying to merge a CI from C to golden where they have different > recon ids then that will never work. > > > >> It should still work if you have written the job properly. If you need to >> you can do a modify all on the Base Element form and set the >> ReconcilliationIdentity to zero. >> >> >> -----Original Message----- >> From: Heanai <seanhea...@hotmail.com> >> To: arslist@ARSLIST.ORG >> Sent: Thu, 22 Jan 2009 2:38 pm >> Subject: Reconciliation IDsâ >> >> >> >> Hello, >> I am having a bit of an issue. I have two datasets A and B. I use the >> econciliation Engine to merge attributes of these two to C. This works >> ine. However when i try to Reconcile C to the Gold Dataset it doesn't >> work >> s C already has a Reconciliation ID. Is there any way around this? >> Thanks, >> ean >> - >> iew this message in context: >> http://n2.nabble.com/Reconciliation-IDs%E2%80%8F-tp2199691p2199691.html >> ent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> _______________________________________________________________________________ >> NSUBSCRIBE or access ARSlist Archives at www.arslist.org >> latinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > > -- View this message in context: http://n2.nabble.com/Reconciliation-IDs%E2%80%8F-tp2199691p2201649.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"