Currently, Personal Email address (e.g. email address ends in outlook.com, hotmail.com, gmail.com, …) is not supported to sign up for PowerApps. PowerApps doesn’t support email addresses provided by consumer email services […]
Read MoreCategory: Informatica
How to extract middle name in Informatica Power center
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 MoreHow 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 MoreHow to remove header and footer records of a flat file using UNIX shell script?
Use the below sed command to delete the Header record. i – Replace the original file1d – delete the first record in the file Use the below sed command to […]
Read MoreHow to add header record to a flat file using unix shell script
Add header to a file using SED command The below sed command will update the original file and insert the header before the first line of the file. 2. Add […]
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 MoreHow to convert Informatica date format YYYYMMDDTHHMMSS
How to convert the date format YYYYMMDDTHHMMSS in Informatica BDM. Yo may have this scenario in the inbound file where the timestamp will come with a string T along with […]
Read MoreAdd Header to a flat file in Informatica BDM
You can add custom header record in an output file in multiple ways, Let’s discuss one quick and easy options in this tutorial. This would be one of the better […]
Read MoreDownload Sample XSD and XML file
Looking for a sample XML file and its layout (XSD) for your testing? You can download the same from the link provided below. Sample XML file: Customers and orders (CustomersOrders.xml) […]
Read More