Question Use of the Incremental_flag in target

Hello,
We need to set a data in a target table of a mapping with the result of the Insert or Update operation :
- If Insert of a row, set the data with 1
- If Update of a row, set the data with 0.

One solution is to join the target table as source with an outer join and test if , but it might be a heavy operation in some case.

Stambia makes use of an Incremental_flag in its integration template.
Would it be possible to re-use this value with a case when / decode directly in the target table ?
How can we access this data in target ?

Is there any other solution ?

Thanks,
Dmaien Espriet

hi Damien,

Currently you can join the source with the target table as you did, or you can setup the target table twice: one for Insertions and the other for Updates.

I'm going to transfer this need to our r&d team, I feel that we can add something in a future version to make this easier...

Edit : you can try to use the incremental flag in your expression, see the attached screenshot. Note that the method and syntax can vary depending on the Rdbms technology and on the selected Template.



Thanks
Thomas