Informatica Source, Target Command Makes File Processing Easier than Before

Johnson Cyriac Feb 14, 2013
|

Source, Target Command Makes File Processing Easier than Beforen
Most of the time when we process flat files in Informatica PowerCenter, we do some kind of file pre or post processing, such as unzip the source file, create a custom header or footer for the target file etc. Such processing is normally done using Unix or Windows scripts, which is called using pre or post  session script. Now Informatica PowerCenter has provided Source, Target Commands to make such processing easy than before.

File Command Property

Using Source or Target Command property, either a Unix or a Windows command can be used to generate flat file source data input rows or file list or a session. Command writes data into stdout and PowerCenter interprets this as a file list or source data. We can use service process variables like $PMSourceFileDir in the command.

Use Cases for File Command Property

In this article, lets discuss couple of use cases, which can be handled easily using File Source, Target Commands. These properties can be further used as per different business needs, but lets see couple of them here.

Use Case 1 : Read a Compressed Source File.

Before the file is read, the file need to be unzipped.  We do not need any other pres session script to achieve this. This can be done easy with the below session setting.
Informatica File Source Target Command Property
This command configuration generates rows to stdout and the Flat file reader reads directly from stdout, hence removes need for staging data.

Use Case 2 : Generating a File List.

For reading multiple file sources with same structure, we use indirect file method. Indirect file reading is made easy using File Command Property in the session configuration as shown below.
Informatica File Source Target Command Property
Command writes list of file names to stdout and PowerCenter interprets this as a file list.

Use Case 3 : Zip the Target File.

We can zip the target file using a post session script. but this can be done with out a post session script as shown in below session configuration.
Informatica File Source Target Command Property

Use Case 4 : Custom Flat File Column Headings.

You can get the column heading for a flat file using the session configuration as below. This session setting will give a file with header record 'Cust ID,Name, Street #,City,State,ZIP'
Informatica File Source Target Command Property

Use Case 5 : Custom Flat File Footer.

You can get the footer for a flat file using the session configuration as given in below image. This configuration will give you a file with *****   End Of The Report   ***** as the last row of the file.
Informatica File Source Target Command Property
These properties can be further used as per different business needs. Hope you enjoyed this article. Please leave your comments and questions, we would like to hear from you.





About US Contact US Advertise Guest Post Terms and Conditions Privacy Policy Disclaimer

© 2012-2013 Data Intelligence Solution, All Rights Reserved
The contents in this site is copyrighted to Data intelligence Solution and may not be reproduced on other websites.