176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

etl enhancement and bugfixing
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 18, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, May 18, 2012
  • 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: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

different tasks in kettle etl and mysql database development, fixing and enhancement.
As discussed with Milos, I have changed it to fixed price, budget 10hrs at 27$/hr.
Goal:


I have two things:



Task 1:

File: 201205161135.frontcontroller.csv.zip
Transformation: stg_frontcontroller_log_8.ktr

column dispatch_id is defined as integer.

We see rows coming that contain a dispatch_id that looks like "%3C!--%3C%user.CampaignAttribute.dispatchId%%3E--%3E"

So all rows that have a dispatch_id like %user.CampaignAttribute.dispatchId% should have the dispatch_id set to null instead of the string.



Task 2:

File: *subscribers.csv.zip

Transformation: stg_subscriberstatus.ktr
There is an error handling which is not really working. I have seen date values starting with 0009.

The process finished successfully but a following process recognizes these date values as datetime2 datatype which causes errors.

These incorrect date values should be set to null (want to keep the row).

Sign in or Register to see more

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

Milos G.      
Milos G.'s identity has been verified.  Learn More
 Serbia  |  
Winner
My field of research covers Data science , Predictive Analysis, Machine Learning, Recommendation engines, ETL (Pentaho kettle- pdi) , Java,...
5
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 30627555  |  Submitted: May 18, 2012 11:59 ET 
Delivery
Within 1 week
$270.01
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 »