Informatica映射以将column1 position1的值分配给column2 position2 [英] informatica mapping to assign values of column1 position1 to column2 position2
问题描述
输入
column1
11
12
13
14
所需的输出
Colmn1 column2
11 Null
12 11
13 12
我已按照以下表达式中的顺序添加了端口,
I have added the ports in the order as below in expression,
column1 - colmn1
V-count - V_count+1
column2 - iif(V_count=1,null,v_col)
V_col - column1
因为我像端口顺序一样研究了执行顺序,所以我最后添加了v_col. 但是对于column2,第一个位置为空,并且column2中的其余值与column1相同.
Since I studied as like the order of ports matters the execution order.so I added the v_col at last. But for column2 1st position is null and the remaining values in column2 are as same as column1.
谁能告诉我该怎么做才能获得预期的结果?
Can anyone tell what should I have to do to get the expected result?
推荐答案
执行顺序确实取决于显示顺序,但仅针对可变端口-Integration Service首先评估 input 端口,然后评估变量(按显示顺序),并在 output 端口(详细信息).
The execution order does depend on the display order but only for variable ports - the Integration Service first evaluates input ports, then the variable ones (in the display order) and last the output ports (details).
您需要两个可变端口:
PORT EXPRESSION
column1 N/A (for in-out port)
v_prev_column1 v_curr_column1
v_curr_column1 column1
column2 v_prev_column1
这篇关于Informatica映射以将column1 position1的值分配给column2 position2的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!