Ignore Existing Record and Insert Other record into DB

3040501

Hi Genius,

Oracle Product: Oracle Data Integrator (12c)

I need a help. A scenario which a flat file that contains 100 records inside, ODI will grab the file and insert into DB.

How to ignore existing record in the file which already exists in the table and proceeds to insert all other records in the same file?

Thanks.

ODI newbie

Jasmine Pauline

Take a look at: https://gurcanorhan.wordpress.com/2014/05/21/odi-ikm-incremental-update-updateless-v1/

HTH-

Jasmine

SH_INT

The scenario you describe is just an incremental update. Choose a KM that supports that load strategy and you should be good to go

3040501

Thanks for your response.

If using an incremental update, is it will updating the existing record in the table also? because I'm afraid it will updating the modified date_time column in the table.

SH_INT

If configured correctly it will only update the modified date_time column in your target if there has actually been a change in the record between loads. If the record hasn't changed it will not be updated

3040501

The problem is I don't want to update the record. I want to skip the record in the file which already exists in the table and proceed insert all other record in the same file.

SH_INT

So if I understand you, some of your existing records are changing in the source but you don't want to update them, even if they change?

3040501

Nope. The existing record is not changed, it will be the same. Totally same. That is why I want to ignore the existing record in the file which already exists in the table because in the table have the primary key on the selected column. Do you get what I mean?

Table: have primary key

If ODI extracts the file and insert into DB and the file contains the same record in the DB, ODI will ignore the record and proceed with another record in the same file. Is it possible for ODI to do that?

Jasmine Pauline

Take a look at: https://gurcanorhan.wordpress.com/2014/05/21/odi-ikm-incremental-update-updateless-v1/

HTH-

Jasmine

3040501

Thanks Jasmine Pauline!!!! it works.