ODI12c中每个映射的最大用户数 [英] Maximum Number of User Per Mapping In ODI12c

问题描述

我是ODI的新手.在ODI项目中工作时，我面临一个问题.

I am new to ODI. While working i ODI Project, I am facing one issue.

我在ODI12c中有10个映射，并且所有映射都使用相同的目标表，但是由于某些性能问题，我希望一次最多只能有2个用户可以执行映射(最大2个映射)，因为他们使用的是相同的目标桌子.如果有2个以上的用户使用同一目标，则该目标不应执行.

I have 10 mappings In ODI12c,and all are using same target table,but due to some performance issue, I want that at a time only max 2 users can Execute mappings(Max 2 mappings), since they are using same target table. If more then 2 user uses that same target then it should not execute.

我应该如何在ODI12c中实现这一点?

How should I implement this in ODI12c?

推荐答案

您可以做一些事情，但不能完全是您所说的.您可以设置名为并发执行控制器"的选项，并告诉方案要等到之前的执行完成为止.

You can do something, but not exactly what you said. You can setup and option called "Concurrent Execution Controller" and tell a scenario to wait until it's previous execution it's finished.

因此，您可以执行下一个:

So, you can do the next:

1.创建一个包

2.为所有映射创建方案

2.create scenarios for all the mappings

3.创建一个变量

2.在程序包内部调用一个方案(无论哪种方案)，并在方案名称处放置变量(请参见下图)

2.inside the package call a scenario (no matter what scenario) and at the scenario name, put the variable (see image below)

3.生成程序包的场景

3.generate scenario for package

4.双击程序包的场景，然后选择限制并发执行"，然后选择等待执行"，然后将等待轮询"间隔设置为X秒以等待

4.double click on the scenario of the package and choose "Limit Concurrent Executions" then choose Wait to Execute and then setup the Wait Polling interval to X seconds to wait

5.执行包方案，并在提示输入变量时，完成要执行的映射的名称

5.execute the package scenario and when the variable it's prompted, complete the name of the mapping you want to be executed

请告诉我是否需要更多信息.

Please tell me if you need more info.

这篇关于ODI12c中每个映射的最大用户数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！