Skip to Content
avatar image
Former Member

File to JDBC scenario ( where clause)

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 17, 2017 at 09:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2017 at 06:57 AM

    please help

    Add comment
    10|10000 characters needed characters exceeded