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
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… 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
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… 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… 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… 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… 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… 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… 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… 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… 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… 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… 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.… 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… Continue reading Stop mapping when a nonfatal error occurs in Blaze Engine Informatica BDM