++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
Sean, Is it possible that you do not identify CIs in datasets A and B against the golden dataset before merging them into C? I guess this would result in the behaviour you are experiencing. If not, can you give us description of all the steps in your process. On the note of merging to a temporary dataset before going to the Golden dataset, I personally follow this approach. The reason being is that I can compare the temporary merged dataset to the Golden one to see what the differences are. If there is far too many, it suggests that discovery data is not quite right and I just get rid of the discovery data and wait for the next run without touching/corrupting the Golden dataset. Regards Jiri Pospisil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Heanai Sent: 23 January 2009 04:05 To: arslist@ARSLIST.ORG Subject: Re: Reconciliation IDs†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" ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify postmas...@lchclearnet.com. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com *************************************************************************************************