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 Unique temp table names?

More
15 Jan 2020 16:57 #1 by cbouin
Unique temp table names? was created by cbouin
Hello,

I have 2 flows which insert data into the same table let's say table "Customers".

The integration templates generate a temp table named "I_Customers", which is destroyed at the end of the mapping.

If I run the flows in parallel, there is a conflict. I can guess the processes do these operations:
- flow 1 creates I_Customers
- flow 1 integrates data
- flow 2 doesn't create I_Customers, since it already exists
- flow 1 drops I_Customers
- flow 2 crashes during data integration, since I_Customers does not exist anymore!

How can I proceed to make sure that temp tables are unique?
More
23 Jan 2020 12:20 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Unique temp table names?
Hi,

You can set the temporary table names in the target metadata, on the Schema node or Table node.
=> See this article for an example, maybe the "With the Mapping Id" paragraph is what you need:
stambia.org/doc/77-development-hints-and...-of-temporary-tables