You might use REG_EXTRACT in an expression to extract middle names from a regular expression that matches first name, middle name, and last name. For example, I have an input […]
Read MoreCategory: Informatica PowerCenter
How to extract first & last name in Informatica Power center
How to split first & last name from a full name In informatica Power center? There are few ways to do this but the recommended and the easy way is […]
Read MoreHow to calculate Age in informatica power center
How to calculate the Age in informatica power center. You can use the function DATE_DIFF. We normally calculate the age by substracting the current date from Date of Birth. In […]
Read MoreDecode function with Regular expression pattern matching in informatica PowerCenter
This post will help you to understand how to match a regular expression pattern in Decode function in informatica PowerCenter. If the requirement is to search for a pattern and […]
Read MoreHow to remove the hash symbol from the flat file header in PowerCenter
How to remove the hash symbol from the flat file header in PowerCenter? You need add a customer property RemoveOutputHeaderHash in the session level. If you are using Header Options to […]
Read MoreHow to add Header Fields To Flat Files in Informatica Power Center (using header command)
How to add Header Fields To a Flat Files in Informatica Power Center using “Header command”? This option will give you the flexibility to fully customize your header names. In […]
Read MoreHow to add Header Fields To Flat Files in Informatica Power Center (using Header Options)
How to add Header Fields To a Flat Files in Informatica Power Center using “Header Options”? This is one of the quick & easy way to print the header columns […]
Read MoreHow to get the last day of the month in informatica
How to get the last day of the month in informatica power center? We can use the transformation function LAST_DAY which Returns the date of the last day of the […]
Read MoreParameterize the Flat File Name & Directory in Informatica PowerCenter
How to Parameterize the Flat File Name & Directory in Informatica PowerCenter. Let’s walk through the steps by parameterizing the target file directory and the file name. Define the workflow […]
Read MorePushdown optimization in informatica PowerCenter
This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. We will see how to implement Pushdown optimization and its limitation. Author: Dhandhaliya Dhiraj Informatica […]
Read MoreStored Procedure transformation in Informatica
Stored Procedure A stored procedure is a precompiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are […]
Read MoreSolution – Create Retail Datamart using Informatica PowerCenter
Certification Project – Create Retail Datamart using Informatica PowerCenter Problem Statement. The purpose of this solution is to explain how to create a retail data warehouse / Datamart using PowerCenter. […]
Read MorePerformance Tuning – Aggregator Transformations
Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the […]
Read MoreSource Based Commits
The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. When the Integration Service runs […]
Read MorePerformance Tuning – Target Bottlenecks
The most common performance bottleneck occurs when the Integration Service writes to a target database. Small checkpoint intervals, small database network packet sizes, or problems during heavy loading operations can […]
Read More