Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Use of the Incremental_flag in target

More
14 Jun 2018 15:35 #1 by Damien ESPRIET
Use of the Incremental_flag in target was created by Damien ESPRIET
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
More
22 Jun 2018 11:11 - 22 Jun 2018 11:22 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Use of the Incremental_flag in target
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
Attachments:
Last edit: 22 Jun 2018 11:22 by Thomas BLETON.