File to JDBC scenario ( where clause)

[Former Member]

Hi, I am working on File to JDBC scenario, Where I need to perform Insert/Update operation on DB. Please find my incoming file structure as below; =========================================

Emp_ID Emp_Name Emp_Dept Emp_Sal =========================================

1 Steve IT 10000

2 John HR 90000

3 Mike Finance 80000

4 Robert IT 70000

5 Jason IT 40000

Question: I need to insert only "IT" department records into table, If the record is already present in the table then I need to update the same. For this, I have used UPDATE_INSERT operation on the mapping and passed the key values as emp_id and emp_dept...still facing the issues. Please help me out. Thanks.

[Former Member]

Hi Steve,

What is the exact issue you are facing? Can you please elaborate on it?

Regards, Supriya.

[manoj_khavatkopp]

Steve,

When you say you need to insert only "IT records " then you need to block the non IT that is Finance /HR use create if and don't create a records for these.

Br,

Manoj

[Former Member]

please help