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 MoreCategory: 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 […]
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 MoreHow 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 […]
Read MoreExecute 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 […]
Read MorePass 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 […]
Read MoreSend 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 […]
Read MoreExecute 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 […]
Read MoreHow 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 […]
Read MoreHow 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 […]
Read MoreHow 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 […]
Read MoreHow 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 […]
Read MoreInformatica 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 […]
Read MoreHow 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. […]
Read MoreStop 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 […]
Read More