有关Informatica电力中心改造任务的问题 [英] Question on informatica power center transformation task

问题描述

我有一个包含名字和姓氏的源表，但是名字旁边的单元格为空白，姓氏之前的单元格为空白.我想把姓氏放在名字的前面

I have a source table containing first name and last name, but the cell next to first name is blank and cell prior to last name is blank. I want to place the last name right in front of first name

来源:

Firstname | lastname
ABC       | <blank>
<blank>   | DEF
GHI       |<blank>
<blank>   |JKL

Desired Output:
Firstname | lastname
ABC        | DEF
GHI        |JKL

推荐答案

您可以将聚合器与MAX()函数一起使用.创建一个聚合器并定义这样的端口-

You can use aggregator with MAX() function. Create an aggregator and define ports like this -

customer_id (set it as group by) - input+output port
in_Firstname = Firstname - input only port
in_lastname = lastname - input only port
out_Firstname = MAX(in_Firstname, NOT ISNULL(Firstname)) - output only port
out_lastname = MAX(in_lastname, NOT ISNULL(lastname)) - output only port

MAX与NOT NULL函数一起将消除所有空数据.每个客户聚合器只会产生1行.您也可以使用排序器来提高性能.

MAX along with NOT NULL function will eliminate all null data. Aggregator will produce only 1 row per customer. You can use sorter too to improve performance.

这篇关于有关Informatica电力中心改造任务的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！