Informatica:根据州名称将数据写入多个文件 [英] Informatica: Write data into multiple files based on State name

问题描述

我有一个带有名为State的列的表.我的要求是从表中读取数据，然后根据州名称将其写入多个文件中.我正在使用Informatica PowerCenter作为ETL工具

I have table with a column called State. My requirement is to read data from the table and write it into multiple files based on State name. I'm using Informatica PowerCenter as ETL tool

推荐答案

创建如下映射:

Source --> SQ (sort data state name)--> Expression --> Transaction Control --> Target

表达式:创建一个变量端口以存储状态的先前值和一个输出端口标志.

Expression: Create a variable port to store previous value of state and a output port flag.

flag = IIF(state = var_state,0,1)
var_state = state

在事务控制转换中，当Flag = 1时使用TC_COMMIT_BEFORE

In Transaction Control Transformation, use TC_COMMIT_BEFORE when Flag = 1

将Filename端口添加到Target并将映射状态名称作为文件名.

Add Filename port to Target and map state name as filename.

这篇关于Informatica:根据州名称将数据写入多个文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！