We know that ODI derives the names of temporary tables from the name of the datastore.
As a result conflicts between multiple simultaneous integration interfaces can arise.
In order to avoid such problems when we are executing parallel scenarios we have to modify the data server to use the ODI Package variables to store prefixes to be used for integration interfaces.
The following steps explain how to do it.
1. Go to the topology manager
2. Edit the physical schema of this target data store
3. In the definition tab,
Replace the existing values set for temporary table prefixes with the name of the ODI package variables.
4. Launch your integration interface from a package in which the ODI variable is declared at the begining.
As a result conflicts between multiple simultaneous integration interfaces can arise.
In order to avoid such problems when we are executing parallel scenarios we have to modify the data server to use the ODI Package variables to store prefixes to be used for integration interfaces.
The following steps explain how to do it.
1. Go to the topology manager
2. Edit the physical schema of this target data store
3. In the definition tab,
Replace the existing values set for temporary table prefixes with the name of the ODI package variables.
4. Launch your integration interface from a package in which the ODI variable is declared at the begining.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.