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 or telecommunications providers currently. If you sign up for PowerApps using your own personal email address, you would receive the following error message: No Worries! […]
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 port for full_name and I want to split and assign the full name as First, Middle & last name. Let’s identify the regular expression for […]
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 to use the function REG_EXTRACT. This function Extracts subpatterns of a regular expression within an input value. Let’s see an example now, I have an […]
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 my case I have date of birth is available in the source file. I have created a port in an expression transformation and calculate the […]
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 delete the footer record. i – Replace the original file$d – delete the last record in the file Use the below sed command to delete […]
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 header to a file using AWK command The below awk command will add header and create a new file. The BEGIN statement in awk makes […]
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 assign the values accordingly, you can configure your DECODE function along with REG_MATCH to match with a pattern. In my case if any plan status […]
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 create header columns in a flat file, you may end up with a hash symbol in the beginning of the header record. To remove that […]
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 this example I am creating a csv target file with comma delimited. Also read another option solution using “Header options” This solution offers a little […]
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 in the target flat file. In this example I am creating a csv target file with Pipe delimited. Also read another option solution using “Header […]
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 month for each date in a port. SyntaxLAST_DAY(pass_the_input_date) Example LAST_DAY( PLAN_END_DATE ) Let’s consider a real time scenarios. We have a PLAN effective date and […]
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 variables for Target file directory & file name Assign the variable fields in the session task Give the location of the parameter file in the […]
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 the actual date & time. This is a valid timestamp in informatica and can be easily converted using to_date function. Let’s see the correct date […]
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 approach If you have very few number of header columns in the target file. Once you define the target file layout, go to its Advanced […]
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) This file contains customers and orders. Customers and orders contains an XSD that can be used to validate this document. It uses the xs:key and xs:keyref features of XSD to […]
Read More