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… Continue reading How to Sign up Microsoft Power Apps without business or work email
Category: 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… Continue reading How to extract middle name in Informatica Power center
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… Continue reading How to extract first & last name in Informatica Power center
How 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… Continue reading How to calculate Age in informatica power center
How 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… Continue reading How to remove header and footer records of a flat file using UNIX shell script?
How 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… Continue reading How to add header record to a flat file using unix shell script
Decode 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… Continue reading Decode function with Regular expression pattern matching in informatica PowerCenter
How 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… Continue reading How to remove the hash symbol from the flat file header in PowerCenter
How 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… Continue reading How to add Header Fields To Flat Files in Informatica Power Center (using header command)
How 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… Continue reading How to add Header Fields To Flat Files in Informatica Power Center (using Header Options)
How 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… Continue reading How to get the last day of the month in informatica
Parameterize 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… Continue reading Parameterize the Flat File Name & Directory in Informatica PowerCenter
How 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… Continue reading How to convert Informatica date format YYYYMMDDTHHMMSS
Add 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… Continue reading Add Header to a flat file in Informatica BDM
Download 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)… Continue reading Download Sample XSD and XML file