Lookup Vs. Fussy Lookup - Masterdata & MDS
-
Hi , please advise?
Would you please advise what will be the best ETL recipe in SSIS for comparing Master Data with other data sources. Below is an example of my Master Data(let's say it is true and correct). I need to compare this data: https://docs.google.com/spreadsheets/d/1TiWk5dPVpJhdUPzBuSBR4_Z15OBGzQW6/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true with my Master Data. How do i go about it?
I would also like to correct spelling in my data set. e.g "Stakeholder" is sometimes spelled wrong. Is MDS the way to go to correct this problem(to have one true correct spelling)?
Thanks,
-
Account Owner & Type would be the columns
in the Master Data i compare with my other data. -
Do you have an example where the master data doesn't equal the imported data? If so, please don't post it as a graphic... post it as readily consumable data. One way to do that can be found in the article at the first link in my signature below.
Of course, you've also been asked to do this before. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - yrstruly wrote:
Account Owner & Type would be the columns
in the Master Data i compare with my other data.Are you really posting actual data in a public forum? This is grounds for termination at my company
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
in the Master Data i compare with my other data.
in the Master Data i compare with my other data.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply