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… Continue reading How to convert Informatica date format YYYYMMDDTHHMMSS
Category: Informatica BDM
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 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… 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) 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… Continue reading Download Sample XSD and XML file
How to get the mapping execution status from a workflow in Informatica BDM
The mapping task will give you the status of the mapping execution as general output. You can define a workflow variable and assign it to the general output section to get the mapping status. The main use case for this option is to route the flow to two different path based on the mapping execution… Continue reading How to get the mapping execution status from a workflow in Informatica BDM
Execute multiple shell commands from a single command task in Informatica BDM
How to run multiple shell commands from a single command task in Informatica BDM. Just separate the commands with a semi colon, The integration service will execute the commands in the given order. One thing to note here, If you run multiple commands like this, the script output will be from the last shell commands… Continue reading Execute multiple shell commands from a single command task in Informatica BDM
Pass workflow variables to mapping in informatica BDM
How to pass parameter and variables from workflow to mapping in Informatica BDM? Let’s see that now by going through the below example. In this mapping the source, target file name & file path are parameterized and assigned from workflow. First let’s define the parameter fields like below in the mapping level. In the workflow,… Continue reading Pass workflow variables to mapping in informatica BDM
Send an email from Notification task in Informatica BDM
A Notification task sends a notification to specified recipients during the workflow. You can send an email notification from a Notification task. For example, you want to track how long a mapping takes to run from a workflow. You include a Notification task in the workflow to send an email containing the time and date… Continue reading Send an email from Notification task in Informatica BDM
Execute Shell script using command task in Informatica BDM
How to Execute Shell script in Informatica BDM using command task. Most of the file operations and other functionalities can be done through a shell script quickly and informatica is providing an option to execute the shell script using a command task. Let’s see how to do that by taking an example. I have a… Continue reading Execute Shell script using command task in Informatica BDM
How to read comma separated data within double quotes in a csv file in Informatica BDM
In real world, most of the csv file will have comma separated data field which will enclose in a double quotes. When you read such kind of file in Informatica BDM, that particular data field looks truncated since the comma within data will be treated like a delimiter. To fix the Issue you need to… Continue reading How to read comma separated data within double quotes in a csv file in Informatica BDM
How to skip header record and read only data records in a flat file in Informatica BDM
If you have a comma separated delimited file with a header record, by default informatica will read all records and process it. If you want to skip the header records and read only data records, give the “start import at line” value as “No of header records”. In the below example since I have only… Continue reading How to skip header record and read only data records in a flat file in Informatica BDM
How to get only filename from find command in Linux?
How to get only filename from find command in Linux? Normally find command will retrieve the filename and its path as one string. If you want to display only the filename, you can use basename command. find {file_path} -type f -iname {file_pattern} -exec basename {} ; find infa/bdm/server/source/path -type f -iname “source_fname_*.txt” -exec basename {} ; Search tags! How do I… Continue reading How to get only filename from find command in Linux?
How to get the script output from informatica BDM command task!
If a command task is executing a shell script, you will get the exit code, standard output and standard error from the script in the Command task output. You can assign these fields to a workflow variable in the “Command Task Output” and use later in the workflow. Let’s consider a shell script which will… Continue reading How to get the script output from informatica BDM command task!
Informatica BDM Naming Conventions – Transformations Objects & workflows
When you use consistent names and descriptions, it is easier to understand the workings of mappings and transformation objects. When you provide a name or description, a developer does not have to spend time going through an object or mapping to understand its objective. Informatica is suggesting us to use some guidelines while developing… Continue reading Informatica BDM Naming Conventions – Transformations Objects & workflows
How to export mapping or workflow parameter file in Informatica BDM?
You can export a mapping parameter file or a workflow parameter file from the Developer tool. Define the parameters in the Developer tool and then export them to a file. The Developer tool creates a parameter file in .XML format. You can export a parameter file that contains mapping parameters or workflow parameters. You can… Continue reading How to export mapping or workflow parameter file in Informatica BDM?
Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM
How to Enable Stop on Errors on the Blaze Engine when a nonfatal error occurs in Informatica BDM, use the property “Blaze.StopOnError,true”! During a mapping run, you may need to interrupt the entire mapping after the Data Integration Service encounters an error or exception. To do this, enable Stop on Errors on the Blaze engine in… Continue reading Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM