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