176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Regular Expressions / Functions for record deduplication in Oracle
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 23, 2013

Job description changed. New Version|Previous Version

May 20, 2013

Job description changed. New Version|Previous Version

May 18, 2013
Close

Job Description

  |  Change History >>

Updated

We have Oracle table of donations where we keep information of each transaction that people make for donations. We only capture First, last and middle name of person with address (Street1, street2, city, state, zip). We need to develop a function or regular expression that should identify and group same person's all transactions even person has multiple variations in name and address columns. System should group all the transactions of one person and create the golden/best record of that person and store in a separate table with unique "person_id". If person files another transaction next time, system should compare it with existing golden/best record and get the person_id from that table and if person does not exist in table (filing first time) then assign new person id to that person. I need this in Oracle SQL and PL/SQL No tools.

We have Oracle table of donations where we keep information of each transaction that people make for donations. We only capture First, last and middle name of person with address (Street1, street2, city, state, zip). We need to develop a function or regular expression that should identify and group same person's all transactions even person has multiple variations in name and address columns. System should group all the transactions of one person and create the golden/best record of that person and store in a separate table with unique "person_id". If person files another transaction next time, system should compare it with existing golden/best record and get the person_id from that table and if person does not exist in table (filing first time) then assign new person id to that person. I need this in Oracle SQL and PL/SQL No tools. uniqueness is based on combination of address and name (first, middle, last). This is not just simple insert, update or merge. It needs some...

May 20, 2013

We have Oracle table of donations where we keep information of each transaction that people make for donations. We only capture First, last and middle name of person with address (Street1, street2, city, state, zip). We need to develop a function or regular expression that should identify and group same person's all transactions even person has multiple variations in name and address columns. System should group all the transactions of one person and create the golden/best record of that person and store in a separate table with unique "person_id". If person files another transaction next time, system should compare it with existing golden/best record and get the person_id from that table and if person does not exist in table (filing first time) then assign new person id to that person. I need this in Oracle SQL and PL/SQL

We have Oracle table of donations where we keep information of each transaction that people make for donations. We only capture First, last and middle name of person with address (Street1, street2, city, state, zip). We need to develop a function or regular expression that should identify and group same person's all transactions even person has multiple variations in name and address columns. System should group all the transactions of one person and create the golden/best record of that person and store in a separate table with unique "person_id". If person files another transaction next time, system should compare it with existing golden/best record and get the person_id from that table and if person does not exist in table (filing first time) then assign new person id to that person. I need this in Oracle SQL and PL/SQL No tools.

May 18, 2013

Close
  • Posted: Sat, May 18, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We have Oracle table of donations where we keep information of each transaction that people make for donations. We only capture First, last and middle name of person with address (Street1, street2, city, state, zip). We need to develop a function or regular expression that should identify and group same person's all transactions even person has multiple variations in name and address columns. System should group all the transactions of one person and create the golden/best record of that person and store in a separate table with unique "person_id". If person files another transaction next time, system should compare it with existing golden/best record and get the person_id from that table and if person does not exist in table (filing first time) then assign new person id to that person.

I need this in Oracle SQL and PL/SQL No tools.

uniqueness is based on combination of address and name (first, middle, last). This is not just simple insert, update or merge. It needs some...

Sign in or Register to see more

Job ID: 41700268
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
I am a programmer with 8 years of experience in Perl, SQL, Sybase, MySQL , MS SQL Server,Postgres, Unix Shell Scripting, sed/awk and Regex. I have...
6
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 41853352  |  Submitted: May 22, 2013 08:05 ET 
Proposal SEALED

 Pakistan  |  
I have over 3 years of professional experience in developing PL/SQL scripts for ETL and Reporting in Oracle's Campus and Banking ERP. Experienced...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41832343  |  Submitted: May 21, 2013 21:28 ET 
Proposal SEALED

 India  |  
We have highly accomplished, skilled and knowledgeable people with extensive knowledge of programming,Business Intelligence,ETL Processing and...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41817756  |  Submitted: May 21, 2013 13:53 ET 
Proposal SEALED

zCon Solutions Pvt. Ltd.      
One or more team members at  are verified.  Learn More
 India  |  
zCon is 7+ years old ISO 9001: 2008 and S&P - CRISIL 'SE 2A' certified ("High Performance Capability and High Financial Strength" ) IT Solutions...
12
  |  
 5.0   |  Private   |  61 Jobs
Bid ID: 41808112  |  Submitted: May 21, 2013 10:16 ET 
Proposal SEALED

 India  |  
I am expert in Talend ETL, I am able to work in various types of databases
1
  |  
 0.0   |  $0 Earnings   |  2 Jobs
Bid ID: 41766416  |  Submitted: May 20, 2013 14:09 ET 
Proposal SEALED

 India  |  
Variya Soft Solutions is offshore development/consulting company which has expertise in Unity 3D, Computer Graphics Designing, Oracle Apex, PHP,...
4
  |  
 5.0   |  Private   |  6 Jobs
Bid ID: 41760729  |  Submitted: May 20, 2013 12:06 ET 
Proposal SEALED

 India  |  
Winner
I have 8 years of IT experience with a very reputed US based IT Service Company and expertise in Data warehousing and Business Intelligence domain....
4
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 41756040  |  Submitted: May 20, 2013 10:28 ET 
Delivery
Within 3 days
$87.67

Mehul Jivani      
Mehul Jivani's identity has been verified.  Learn More
 India  |  
I have 2 years experience in Oracle Plsql Developer
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41750004  |  Submitted: May 20, 2013 08:03 ET 
Proposal SEALED

 India  |  
SPEC INDIA, a ISO 9001:2008 certified company specializes in providing IT services and solutions in Java, Microsoft, iOS, Android, Database, Big...
12
  |  
 4.5   |  Private   |  31 Jobs   |  5 verified credential(s)
Bid ID: 41748871  |  Submitted: May 20, 2013 07:32 ET 
Proposal SEALED

 India  |  
Expertise Oracle DBA, Linux, Unix, PL/Sql, Vb 6.0. Ms Access Databse. Ms excell Macro.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41737151  |  Submitted: May 20, 2013 02:03 ET 
Proposal SEALED

 India  |  
Having more than 10 years of experience in Oracle, PLSQL, SQL, Performance tuning, Informatica, Datastage and Teradata
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41732470  |  Submitted: May 19, 2013 22:57 ET 
Proposal SEALED

 India  |  
Oracle Certified Professional in SQL/PLSQL and SOA Experienced and passionate Coder who follows the idea of great quality work with minimum...
4
  |  
 4.4   |  Private   |  3 Jobs
Bid ID: 41730611  |  Submitted: May 19, 2013 21:18 ET 
Proposal SEALED

 India  |  
KneemTree is a business intelligence consulting and services company founded by experts in related areas. KneemTree delivers solutions that provide...
3
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 41723696  |  Submitted: May 19, 2013 14:42 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »