Retain Values from Previously Processed Record Using Variable Ports

Johnson Cyriac Jun 30, 2012
character encoding in Informatica powercenter workflow
There can be many scenarios where you need the previous record's data to do some calculation, while the current record is processed in an informatica mapping. For example you need the previous days closing balance to calculate the loss or gain while processing the current day's data. Here in this tutorial we will discuss some techniques to get the previous record values while we are processing current record in a mapping.

Informatica Mapping to Populate Header Values to Detail Records from a Flat File

Johnson Cyriac Jun 24, 2012
|
character encoding in Informatica powercenter workflow
Many times it is possible that you get flat files with a header record, which has a different structure from the other detail record.  The header record gives some audit information like Number of total records in the file, File creation date, Unique file identifier etc... which aslo makes some business value. You can be asked to populate these header record column to the target along with each detail records from a Flat File Source.

Split Your Informatica PowerCenter Target File Dynamically Based on the Content

Johnson Cyriac Jun 19, 2012
|
Split your target file dynamically based on the content
There can be scenarios, where you need to generate multiple flat file using an informatica mapping based on the source data content or some other business rule; from a single data source. For example, you may need to generate last months top revenue generating customer list, which is split into multiple files based on the customer residence state. In this article we will see how to split your target file dynamically based on the business rule.

Dynamically Change Your Target Flat File Name Using Informatica Mapping

Johnson Cyriac Jun 15, 2012
|
character encoding in Informatica powercenter workflow
When ever you create a flat file using a PowerCenter Workflow, the name of the file will be static, which is specified in the Session 'Output Filename' property.  There can be business cases where you need to generate flat files with dynamic file name, like add Timestamp with the file name . Here in this article we will discuss how we can generate flat files with dynamically changing name.

Customize Your Target Flat File Column Headings Using Informatica Mapping

Johnson Cyriac Jun 12, 2012
|
character encoding in Informatica powercenter workflow
When you create flat file using a Power Center workflow, it creates the file with target table port name as the column headings, But you might need to change the column heading, which make more meaning to the column data before it can be given to the business users. Here in this article we will see how we can customize the target file column header.



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.