Prize amount increased: Pentaho Kettle Data Integration

Cancelled Posted Jul 20, 2012 Paid on delivery
Cancelled Paid on delivery

Attached is a PDI Pentaho Kettle Data Integration job which I created in Spoon. This is a very simple job, it reads from two separate comma-separated CSV files, joins them together through a common primary key, and writes the result to a database table. I need this solution to be expanded to implement the following requirements:

1. Pass date as input parameter;

2. Use date parameter in input filenames and in building the SCD table;

3. Address look up against database;

4. Address look up against Web Service when not found in database;

5. Write to Slowly Changing Dimension;

6. Rename and compute the fields according to specification shown in Transformation 2, but this must be done inside of Transformation 1 using something like the Formula Step, then Eliminate Transformation 2;

7. Create a separate table to maintain information about each file processed, like filename and timestamps;

8. Explain how to Deploy the completed job to Linux Ubuntu 12.04 server.

The first contestant to demonstrate a solution that satisfies all requirements during the public phase of the contest, will be selected to upload the actual solution in a private message.

This contest is public. Please check other contestant's threads before asking questions.

Education & Tutoring Engineering Java Linux Microsoft MySQL PHP Script Install Shell Script Software Architecture Software Testing Windows Desktop

Project ID: #2761383

About the project

Remote project Active Jul 22, 2012