Prize amount increased: Pentaho Kettle Data Integration
$30-75 USD
착불
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.
프로젝트 ID: #2761383