Data Quality Management
₹37500-75000 INR
Bezahlt bei Lieferung
aim of my project is to do Reference data automation.I have data in Sql server (Database 1 and Database 2).The data is is not in proper way that we can access directly. So first I have to do the analysis from the database [url removed, login to view] I have categorized the data into valid and invalid after [url removed, login to view] i sent it to SME's for review the [url removed, login to view] that started with grouping the data for the correspond groups and sub groups in a seperate table called Group [url removed, login to view] steps followed for both [url removed, login to view] Again send it for review whether correct grouping done or not. After that collected distinct records(reference data id's ,groups and sub groups) from both data databases and inserted into the global [url removed, login to view] any database came like database 3 in future again no need to do the analysis on that database for that one i had created a stored procedure it will do the data categorization,grouping and maintaining in the global table.
FEATURES :
[url removed, login to view] are created on Global table to trigger all updates at all group table levels,instead of going to each group table and updating manually.
[url removed, login to view] procedure with parameter as source table on which we want to do the analysis.
Example :
Data id =1 has code value as 'Male' in Database 1
Data id =1 has code value as 'M' in Database 2
There is a data inconsistency from those database tables but the meaning is same. So i have fixed that problem by above steps.
Finally
Group tabel has following columns
[url removed, login to view] Name
[url removed, login to view] Group
[url removed, login to view] Id
[url removed, login to view] Flag
Global Table has following columns
[url removed, login to view] Name
[url removed, login to view] Group
[url removed, login to view] Id
[url removed, login to view] Name(database 1/database 2/database 3 etc)
[url removed, login to view](count of code values from database 1/database 2/database 3 etc)
[url removed, login to view] 1(Flag for data id whether existing or not Y/N)
[url removed, login to view] 2(Flag for data id whether existing or not Y/N)
Projekt-ID: #6055460
Über das Projekt
10 Freelancer bieten im Durchschnitt ₹55726 für diesen Job
I have worked with sensitive data from online banking transactions to personal health care information. I am very detailed oriented and analytical with over 18 years of SQL Server Experience.
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft software a Mehr
Have been working on SQL server for last 5 years in IT . Had worked for Very Big Clients like Microsoft and HP etc.. No Doubt , that we can deliver your product with in 20 days .
I am a developer with over 6 years of experience and a masters degree to support my case. I have mainly worked on SQL Server and believe I can help you with your problem, My bid will be fixed even if the work requir Mehr
Hi Guys, Myself yogesh and i am working on MSSQL server for last 5+ years and had worked on MSSQL Server Versions 2005,2008,2008 R2,2012. Below is a short description of my expertise in this field: Information Tec Mehr