Pentaho勺子工具转换顺序 [英] Pentaho Spoon Tool Transformation Order

问题描述

我正在尝试设计ETL结构，并且在下面的步骤中遇到了麻烦.

I am trying to design an ETL structure and i stucked in the below step.

如您所见，我有3个步骤，每个步骤都保留上一步的 FK 值.例如， TABLE3 的列包含 FK约束，该列显示 TABLE2 和 TABLE2 与 TABLE1 具有相同的关系.

As you can see i have 3 steps and each step holding a FK value from previous step. For example TABLE3 has a column with FK Constraints which shows the PK value in TABLE2 and TABLE2 has same relationship with TABLE1.

问题是，当我开始执行此作业时，所有这三个步骤同时运行，并且由于TABLE2试图在TABLE1创建完成之前设置FK，所以出现了有关FK约束的错误.

The problem is when i start this job all these 3 steps are running simultaneously and error is occuring about FK constraints since TABLE2 trying to set a FK before TABLE1 creation completes.

我不确定这是否是创建ETL流程的最佳实践，但是是否可以按指定的顺序运行这三个步骤?

I am not sure if this is the best practice for creating an ETL process but is there a way to run these 3 steps in specified sequence?

推荐答案

我的解决方案；

在设计"面板中流程"步骤下有一个有用的工具，称为阻止此步骤，直到步骤完成"，它可以帮助您观察所需的步骤，而不是开始被阻止的步骤，这样您就不会对FK和其他依赖项.这是实现；

In Design panel under the Flow steps there is a usefull tool called "Block this step until steps finish" which helps you observe the steps you want and than start the step which is blocked so that you will have no problem with FK and other dependencies.. Here is the implementation;

这篇关于Pentaho勺子工具转换顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！