Skip to Content
0

File to JDBC scenario ( where clause)

Jan 16, 2017 at 07:21 PM

35

avatar image

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.

10 |10000 characters needed characters left characters exceeded

Hi Steve,

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

Regards, Supriya.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Manoj K Jan 17, 2017 at 09:56 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Steve Janishaw Jan 17, 2017 at 06:57 AM
0

please help

Share
10 |10000 characters needed characters left characters exceeded