Re: Reconciliation IDsâ
Jiri just posted the thoughts I was having. Cheers Peter 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Reconciliation IDsâ
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
Re: Reconciliation IDsâ
Yaa C already has a Recon ID after the record was created from A and B. You said in another post that BMC recommended this as a Best Practise, how would they have intended this to work then? 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-tp2199691p2201637.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
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