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屋！