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
Category: Informatica
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
FREE Cloud Integration for Application Modernization Foundation Level Certification
Application modernization, the process of taking existing legacy applications and corresponding data and modernizing their infrastructure, architecture, and/or features, is an $11 billion market expected to grow to about $25 billion by 2025. Application modernization is typically focused on monolithic, on-premises applications and how those applications can be brought into modern, cloud-native architecture. The benefits… Continue reading FREE Cloud Integration for Application Modernization Foundation Level Certification
FREE Informatica MDM Business 360 Foundation Level Certification
The Informatica Business 360 Foundation series offers you the very latest training and the opportunity to become certified to Foundation Level in Master Data Management and 360 Solutions. Just complete the 3 video series and pass the related quiz to earn the “Business 360 Foundation Level” certification. Session 1: Business 360: Master Data Management Session… Continue reading FREE Informatica MDM Business 360 Foundation Level Certification
FREE onDemand training on Cloud Application Integration Services for Developers
Want to master in Cloud Application Integration?? Informatica is providing FREE training on Cloud Application Integration Services for Developers. This course is applicable to version R33. Gain the skills necessary to integrate applications and systems, implement business processes using process designer that can access data from on-premise as well as cloud, and expose them as… Continue reading FREE onDemand training on Cloud Application Integration Services for Developers
06 Troubleshooting: Tips for Informatica PowerCenter Specialist Certification!
There will be 5 questions from this topic. What to study & Where to focus Workflow Basics Guide Chapter 14: Session and Workflow Logs Message Severity (Page 239) Log Events Window (Page 241) Workflow & Session Logs (Page 246) Advanced Workflow Guide Chapter 8: Row Error Logging General topics What are the scenarios/reason when a… Continue reading 06 Troubleshooting: Tips for Informatica PowerCenter Specialist Certification!
How to get the counts of deleted files in unix/linux
How to get the counts of deleted files in unix/linux If you want to get the deleted files count by your rm command, use the verbose option (-v) and wc -l. To delete a file rm -f source_fname_*.txt To get the counts of deleted files rm -vf source_fname_*.txt | wc -l To find & delete… Continue reading How to get the counts of deleted files in unix/linux
How to find all writable files by a specific user in unix
Linux find command to list all files writable by a specific user To find all writable files in current directory that are writable by the current user: use the command writable find . -writable To find all writable files in a specific directory that are writable by the specific user: find {file_path} -writable -user {user_id}… Continue reading How to find all writable files by a specific user in unix
Pushdown optimization in informatica PowerCenter
This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. We will see how to implement Pushdown optimization and its limitation. Author: Dhandhaliya Dhiraj Informatica ETL Developer | SQL Developer | IICS Developer | IDQ Developer Email | Linkedin Profile What is Pushdown Optimization? Pushdown Optimization is use to increase… Continue reading Pushdown optimization in informatica PowerCenter
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
05 Transformation language: Tips for Informatica PowerCenter Specialist Certification!
There will be 6 questions from this topic. There is one entire pdf document is talking about this topic. You can download the document from the below url. This describes how you can use constants, operators, variables, dates, and functions to transform source data. Transformation Language What to study & Where to focus Even-though its… Continue reading 05 Transformation language: Tips for Informatica PowerCenter Specialist Certification!