How to terminate the workflow in case of task/mapping failure in Informatica BDM! Use Terminate Event” By default the workflow will be marked as success even-though any of the mapping or tasks failed. You can use the “terminate event” to force a workflow to fail in case of any mapping or task failed. Add an… Continue reading How to terminate a workflow and mark the status as failed in Informatica BDM
Category: Informatica BDM
Stop mapping when a nonfatal error occurs in Informatica BDM
How to stop the mapping when a nonfatal error occurs in Informatica BDM, enable function “Stop on Errors”! “Stop on Errors” stops the mapping if a nonfatal error occurs in the reader, writer, or transformation threads. There is no threshold to set along with this property, As soon as the mapping encounter any reader/writer/transformation… Continue reading Stop mapping when a nonfatal error occurs in Informatica BDM
INFACMD command to export workflow parameter file in Informatica BDM
How to export workflow parameter file using INFACMD command? Use listWorkflowParams! 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… Continue reading INFACMD command to export workflow parameter file in Informatica BDM
INFACMD command to export mapping parameter file in Informatica BDM
How to export mapping parameter file using INFACMD command? Use ListMappingParams! 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… Continue reading INFACMD command to export mapping parameter file in Informatica BDM
Parameterizing relational tables in Informatica BDM
Parameterizing relational table object in BDM We have an Oracle relational table called “Explore_Infa_Table”. Let’s see how to parameterize the connection, table and schema name. We cannot create/define parameters in the object level. This should be done in mapping level and then link with the run time fields in the object. Go to Advanced property… Continue reading Parameterizing relational tables in Informatica BDM
Parameterizing the Flat File Name & path in Informatica BDM
Parameterizing the Flat File Name & Directory in BDM Define parameter fields in flat file data object Assign parameter fields as values the Read/Write session in flat file data object Define parameter fields in mapping level Link data object parameter fields with mapping parameter fields Define parameter fields in workflow level Link and pass the… Continue reading Parameterizing the Flat File Name & path in Informatica BDM