Data Quality Management

Geschlossen Veröffentlicht Jun 11, 2014 Bezahlt bei Lieferung
Geschlossen 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)

Microsoft SQL Server

Projekt-ID: #6055460

Über das Projekt

10 Vorschläge Remote Projekt Aktiv Jul 18, 2014

10 Freelancer bieten im Durchschnitt ₹55726 für diesen Job

amarcel20

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.

₹50277 INR in 15 Tagen
(1 Bewertung)
1.5
skhan81

As explained below, I need to migrate the inconsistent data from Database 1 to Database 2 along with the transformation to make it proper, meaning full consistent data. To do this, I assume MS SQL Server Databases b Mehr

₹50000 INR in 15 Tagen
(0 Bewertungen)
0.0
abdellatif81

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

₹59210 INR in 8 Tagen
(0 Bewertungen)
0.0
manasamajeti

A proposal has not yet been provided

₹62500 INR in 20 Tagen
(0 Bewertungen)
0.0
kiransabbana

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 .

₹52222 INR in 20 Tagen
(0 Bewertungen)
0.0
cooldude0609

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

₹48054 INR in 15 Tagen
(0 Bewertungen)
0.0
ishanshaik

A proposal has not yet been provided

₹62500 INR in 30 Tagen
(0 Bewertungen)
0.0
yogeshpandey86

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

₹55555 INR in 12 Tagen
(0 Bewertungen)
0.0
digitwork

A proposal has not yet been provided

₹62500 INR in 7 Tagen
(0 Bewertungen)
0.0
AnDelf

If I undestood you coorrectly, you need to create Table of refrences, wich will be used to connect different data in different databases. After that you want to analyze new databases in similar way to increase the spee Mehr

₹54444 INR in 12 Tagen
(0 Bewertungen)
0.0