Retain Values from Previously Processed Record Using Variable Ports

Retain Values from Previously Processed Record Using Variable Ports

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.

Continue Reading

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

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

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.

Continue Reading

Split Your Informatica PowerCenter Target File Dynamically Based on the Content

Split Your Informatica PowerCenter 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.

Continue Reading

Dynamically Change Your Target Flat File Name Using Informatica Mapping

Dynamically Change Your Target Flat File Name Using Informatica Mapping

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.

Continue Reading

Customize Your Target Flat File Column Headings Using Informatica Mapping

Customize Your Target Flat File Column Headings Using Informatica Mapping

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.
Continue Reading