tag:blogger.com,1999:blog-4926720154216717289.post2450806104107174342..comments2023-09-07T07:38:12.948-07:00Comments on SQL & BI: MDM (Master Data Management) Business ScenarioManish Kumarhttp://www.blogger.com/profile/04289615508941239125noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4926720154216717289.post-89485555341833444242018-05-16T01:38:41.510-07:002018-05-16T01:38:41.510-07:00Hello There,
Very cool to see your post come up ...Hello There,<br /> <br />Very cool to see your post come up when I was searching this topic! <br /><br />If the pkey_src in stage exists in BO_XREF then it updates the XREF table and based on trust/recency the update to XREF <a href="https://medium.com/@infamdm02/mdm-tutorial-b3d750f5df3d> will propagate </a> to BO. If the pkey_src doesn't exist in BO_XREF it inserts a row in XREF table and also inserts/creates a new BO with a new rowid_object (unless it is a load by rowid in which case XREF will be created but added to an existing BO record for which rowid is given in mapping and if it would survive to BO or not is dependent on trust/recency)<br /><br />But great job man, do keep posted with the new updates. <br /><br />Cheers,<br />Preethi <br />Anonymoushttps://www.blogger.com/profile/04321217709942391508noreply@blogger.com