Simple Talend Project

Note - All dates must be in yyyy-MM-dd format in database

Q 1 -

Process Consumer Complaint file A only as per instructions below

1) Read file A, remove duplicates; load to table Consumer_Complaints;

2) Print no of records processing at the count of 5000, and total count in console

Q 2 –

Process multiple consumer complaints file as per instructions below –

1) Read Consumer Complaints file A, remove duplicates, load to table Consumer_Complaints (mysql) ordered by date_received

2) Reject data in Rejects file with blank Complaint ID

3) Read Consumer Complaints file B, remove duplicates and blank complaint ID and -

a) exactly same (same data in all fields) record must be rejected if it already exists in table

b) if Complaint ID exists, then update table else insert

4) Read data from DB Generate single excel report; with each of the following in different sheet within same excel

a) Sheet “Product Complaint” – Count Issues per product and State combined launched after 10/30/2014

b) Sheet “Medium” – Count issues submitted through different mediums per Company, State and Product combination

5) Create csv file for all data which has untimely response and consumer disputes

Habilidades: Processamento de dados

Ver mais: example simple design project, simple palindrome project java, simple flash project rotating images, simple bank project servlet jsp, simple digital project, simple jsp project eclipse, simple database project, project embedded projects single page, simple design project, simple php project, simple java project code, simple access project, instructions simple machine project, simple test project php, simple excel project grade

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #15817299

6 freelancers are bidding on average $151 for this job


please hire me Relevant Skills and Experience excel

$155 USD in 3 dias
(0 Comentários)

I can type Tamil [url removed, login to view] I will take time very short. Relevant Skills and Experience Data processing is a simple work for me.

$155 USD in 3 dias
(0 Comentários)

i will do this project correctly and quickly Relevant Skills and Experience i have relevant experiences and skills to complete this project correctly like data processing Stay tuned, I'm still working on this propos Mais

$166 USD in 2 dias
(0 Comentários)

You want the job done right. Efficiently and effectively. My bid represents a quality job well done.

$166 USD in 3 dias
(0 Comentários)

I have good skill in typing. I have 5 years experience in the relevant field. I can get your project completed with 100% accuracy. Please consider in assigning the project to me. Relevant Skills and Experience I have Mais

$155 USD in 3 dias
(0 Comentários)

Hi, I can do this for you. I have done a course of database from coursera. we can discuss further details about it. waiting for your response. cheers

$111 USD in 3 dias
(0 Comentários)