sql server - DQS How to cleanse duplicates in master table and correct IDs in all referenced tables -

-

we have lots of duplicates in master table. see below example, customer abc corp exists 3 times in master table , 3 custids referenced in orders table.

**customers table**  <table>  <tr><td><strong>custid</strong></td><td><strong>custname</strong></td></tr>  <tr><td>1001</td><td>abc corp.</td></tr>    <tr><td>1002</td><td>xyz corp.</td></tr>    <tr><td>1003</td><td>abc corp ltd.</td></tr>    <tr><td>1002</td><td>abc corporation limited.</td></tr>    </table>      **orders table**  <table>  <tr><td><strong>orderid</strong></td><td><strong>custid</strong></td></tr>  <tr><td>23425</td><td>1001</td></tr>    <tr><td>23466</td><td>1003</td></tr>    <tr><td>23488</td><td>1003</td></tr>    <tr><td>43877</td><td>1004</td></tr>    </table>

how can use data quality services remove duplicate customers customers table , update orders table reflect changes.

i.e. custids 1003 , 1004 merged 1001 , 1003 , 1004 orders table need updated 1001 too.

what have done far. created knowledge base customers synonyms custname , defined leading value. , created data cleansing project in dqs , analysed data , made corrections master data , imported corrected values customers knowledge base. understood dqs cleansing transformation in ssis automatically connecting source table , dqs kb , gives matching , non matching rows, still don't understand here. how data in customers table corrected , orders table updated accordingly. please suggest. examples have seen far using pretty basic stuff table , simple excel sheet.

geek,

when run sql server data quality service project cleansing last step wizard requests how export results.

if choose same source table target, replace original data new data after cleansing

but think best option export data temp table, execute sql query update validated changes

i had countrylist table. running dqs project data cleansing purpose , exported results (data cleansing info) new table countrylistdqs in sql server database

later, running sql update statement similar below can update original data validated changes dqs

update dbo.countrylist set     country = q.country_output dbo.countrylist c inner join dbo.countrylistdqs q on c.id = q.id_output q.country_status = 'corrected'

Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more