Author: kvt

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

How to terminate a workflow and mark the status as failed in Informatica BDM

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

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

FREE Informatica Cloud Lakehouse Data Management Certification

Cloud Lakehouse Data Management (Foundation Level) Complete the new three-part virtual enablement series on Cloud Modernization to qualify for Cloud Lakehouse Data Management (Foundation Level) certification.  Just attend the on demand video sessions and complete the quiz at the end to get the certification for each series. After completing all the three series you can… Continue reading FREE Informatica Cloud Lakehouse Data Management Certification

How to create a Reusable task in Workflow Designer?

Can we create a Reusable task in Workflow Designer? The answer is yes. When you create a task in workflow designer its non-reusable by default. But you can always promote this to a reusable task. This action cannot be reversed.   Creating a Task in the Workflow or Worklet Designer You can create and add… Continue reading How to create a Reusable task in Workflow Designer?

Free Informatica Training – Enroll now!

Informatica University is offering Free Training. Join these two-hour sessions to enhance, extend, and deepen your knowledge. These sessions will focus on topics that will provide additional expertise in an Informatica solution focusing on one or more products.  Train in Two- InfaTech Topics Sessions Topic Description Date/Time Register Feeding Change Data Capture (CDC) with Big… Continue reading Free Informatica Training – Enroll now!

Sr. Informatica B2B Developer (DX/DT) @ Philadelphia, PA

Sr. Informatica B2B Developer (DX/DT) Philadelphia, PA 18-24+ months $90/hr. (all inclusive)- flexible for an expert 1/7/19 My direct client is in need of a Sr. Informatica B2B Developer with expertise around DT (Data Transformation) and DX (Data Exchange). The ideal candidate must have proven experience with parsing XSD and EDI files, and API’s to… Continue reading Sr. Informatica B2B Developer (DX/DT) @ Philadelphia, PA