I guess my issue is that I do not have a GOLD set yet. I have many different sources for data that will become the GOLD set but need to first identify and then merge them.
On Tue, Aug 11, 2009 at 8:02 PM, Lyle Taylor<tayl...@ldschurch.org> wrote: > Items can only be matched between datasets where the item in the master > dataset already has a reconciliation ID. So, if the ID is zero in both > datasets, the items will never match. The usual process is that you will > auto-identify the records (or some portion of them based on criteria that you > set in a qualification group) in the master dataset, and then you will run an > identification activity with the other dataset to see which items in the > second dataset match the items that you have already identified in the first > dataset. > > If neither of the datasets that you are talking about is the gold dataset > (BMC.ASSET), it would be good to first run an identification activity between > gold and one or both of the secondary datasets. That way, you match up any > discovery items that already match gold. Then you can auto-identify items in > one of the secondary datasets to identify new items that will eventually get > merged into gold. Then, lastly, you can run an identification activity > between the two secondary datasets to find all items that match between them, > and merge the final results into gold if you want. > > Does that make sense? > > Lyle > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso > Sent: Tuesday, August 11, 2009 3:35 AM > To: arslist@ARSLIST.ORG > Subject: Reconciliation - Identification Stage > > ARS 7.1p5 > SQL Server 2005 > CMDB 2.1 p4 > > Have two datasets that were created from two different discovery > sources. Each has several BMC Computer records. The reconciliation ID > in both is set to 0 as neither has never been reconciled with another > source. > I created an identification activity to compare the two datasets > matching on the Name. I set one of the datasets as the master in the > activity. When I run the activity the second data set (non master) > records gets assigned reconciliation IDs but the master dataset > records do not. It is my understanding that the identification > activity would match records in the two datasets and give them the > same reconciliation id. If I then take the identification job and > reverse the roles of each dataset and rerun the job the records on > both sides will get reconciliation ids that match. > > So it looks like you can do this sort of comparison but only when one > dataset already has been reconciled? > > Does this make sense or am I missing something. > > TIA > > Frank > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > > NOTICE: This email message is for the sole use of the intended recipient(s) > and may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy all > copies of the original message. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"