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
相关问题
- Can ETL informatica Big Data edition (not the clou
- DTS/SSIS vs. Informatica Power Center
- INFORMATICA - Date format conversion
- informatica multi correlated subquery implementati
- PowerCenter REG_EXTRACT issue
相关文章
- 的PowerCenter REG_EXTRACT问题(PowerCenter REG_EXTRACT
- 的Informatica - CONCATENATE 1列的所有行的单个值(Informatic
- Informatica的映射来分配列1将position1的值COLUMN2位置2(informat
- 对Informatica的的PowerCenter SQL Server存储库(SQL Server
- Informatica的的PowerCenter VS定制的Perl ETL作业?(informat
- 快照太旧错误(Snapshot too old error)
- INFORMATICA - Date format conversion
- informatica multi correlated subquery implementati
You can also do this using post shell command:
Create a mapping as below:
Expression: Create a variable port to store previous value of state and a output port flag.
In Transaction Control Transformation, use TC_COMMIT_BEFORE when Flag = 1
Add Filename port to Target and map state name as filename.