触发基于oracle表数据运行的不同Informatica工作流 [英] Trigger Different Informatica workflows run based on oracle table data

问题描述

方案:有多个源系统，每个系统都有各自的工作流程.我将查询/读取文件/表，以检查其中提到了哪个源系统，并且将基于该特定工作流运行.

Scenario: there are multiple source systems and individual workflows present for each of them. I shall query/read a file/table to check which source system is mentioned there and based on that specific workflow will run.

来源WFnames1 w1s2 w2s3 w3

Source WFname s1 w1 s2 w2 s3 w3

在文件/表中，如果我找到s1和s3，则应该触发w1和w3.我有Windows系统，如果您建议使用批处理脚本，请发送样本给我，因为我不是批处理脚本的专家.

In the file/table if I have find s1 and s3 then w1 and w3 should fire. I have windows system,If you are suggesting batch script please send me sample as I am not expert in batch script.

推荐答案

我为UNIX创建了一个，所以没有针对Windows的确切脚本.我遵循的步骤-

I created one for UNIX so dont have exact script for Windows. Steps i followed -

1. 基于依赖关系将工作流分成几组-将它们命名为1,2,3组...将列表放在表中.

2. 拾取组1并循环...

1. Split workflows in groups based on dependency - name them group 1,2,3... put the list in a table.

2. pickup group 1 and loop...

2.1.选择第一个工作流程，使用"pmcmd startworkflow"启动它.选择下一个启动它.这样做直到第1组中的所有成员都用尽.在表中将状态记录为正在运行".

2.1. pick first workflow, use 'pmcmd startworkflow' to start it. Pick next start it. do this until all in the group 1 exhausts. Log status as 'Running' in a table.

2.2.创建无限循环-运行pmcmd getworkflowdetails来逐一检查组1中工作流的状态.如果一切成功，则退出此循环.否则继续投票.表中的日志状态.表中的日志状态为成功".如果任何流失败，请记录状态失败"并退出外壳.检查状态可能很棘手-您需要存储输出并查找'[Succeeded]'字样.

2.2. create infinite loop - run pmcmd getworkflowdetails to check status of workflows in group 1 one by one. if all succeeds just exit this loop. else keep polling. Log status in a table.Log status as 'Succeeded' in a table. If any flow fails, log status 'Failed' and exit the shell. Checking status can be tricky - you need to store the output and look for '[Succeeded]' word.

这篇关于触发基于oracle表数据运行的不同Informatica工作流的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！