Email task, Session and Workflow notification : Informatica

One of the advantages of using ETL Tools is that functionality such as monitoring, logging and notification are either built-in or very easy to incorporate into your ETL with minimal coding. This Post explains the Email task, which is part of Notification framework in Informatica. I have added some guidelines at the end on a few standard practices when using email tasks and the reasons behind them. 1. Workflow and session details. 2. Creating the Email Task (Re-usable) 3. Adding Email task to sessions 4. Adding Email Task at the...

Informatica Unable to fetch log

Quite often, you might come across the following error when you try to get the session log for your session. Unable to Fetch Log. The Log Service has no record of the requested session or workflow run. The first place to start debugging this error would be one-level up from the session log, which is the workflow log. The most common reasons I have seen this happen is because of the following . a ) One or more of the following parameters have been specified incorrectly. Session Log File directory Session Log File Name Parameter Filename (at the session (and/or) workflow level) b) You do not have the necessary...

Informatica Workflow Successful : No Data in target !

This is a frequently asked in the Informatica forums and the solution is usually pretty simple. However, that will have to wait till the end because there is one important thing that you should know before you go ahead and fix the problem. Your workflow should have failed in the first place. If this was in Production, Support Teams should know that something Failed. Report users should know the data in the Marts is not ready for reporting. Dependent workflows should wait until this is resolved. This coding practice basically violates the Age-old Principle of fail-fast when something goes wrong, instead of continuing...

ORA-01403: no data found

Pretty common oracle error. Raised when you are trying to fetch data from sql into a pl/sl variable and the sql does not return any data. >> Using the data from this schema   SQL> SELECT COUNT(*) FROM scott_emp WHERE empno = 9999;   COUNT(*) ---------- 0   SQL> DECLARE l_ename scott_emp.ename%TYPE; l_empno scott_emp.empno%TYPE := 9999; BEGIN SELECT ename INTO l_ename FROM scott_emp WHERE empno = l_empno; END; /   DECLARE * ERROR at line 1: ORA-01403: no DATA found ORA-06512: at line 5 What to do next 1. Re-Raise it with a error message that provides...

Introducing Informatica Cloud 9 – The Defining Capability For Cloud Computing

Today we made an announcement called Informatica Cloud 9.  This is the culmination of many years of hard work and effort and builds on the Informatica 9 announcement we made last week.  So what is so special about Informatica Cloud 9?  Is it the new Platform-as-a-Service offering?  Or it is the new Cloud Services we delivered?  Or is it the new capabilities on Amazon EC2?  What are all these things and why are they important? Let me explain: Informatica Cloud 9 started over four years ago when we noticed the beginnings of a revolution happening around us – namely Cloud Computing.  Many...

How Big Data Changes Data Integration

With Big Data systems now in the mix within most enterprises, those charged with data integration are interested in how their world will soon change. Rest assured, most of the patterns of integration that we deal with today will still be around for years to come. However, there are some clear trends that data integration managers need to understand, such as: The ability to imply structure to the data at the time of use. The ability to store both structured and unstructured data. The need for faster data integration technology. The ability to imply structure to the data at the time of use refers to the fact that Big...

How Integration Platform-as-a-Service Impacts Cloud Adoption

Did you know that Forrester estimates in their 10 Cloud Predictions For 2012 blog post that on average organizations will be running more than 10 different cloud applications and that the public Software-as-a-Service (SaaS) market will hit $33 billion by the end of 2012? However, in the same post, Forrester also acknowledged that SaaS adoption is led mainly by Customer Relationship Management (CRM), procurement, collaboration, and Human Capital Management (HCM) software and that all other software segments will “still have significantly lower SaaS adoption rates”. It’s not hard to see this in the market today, with...

Delivering IT Value with Master Data Management and the Cloud

Over the last few years most enterprises have implemented several (if not more) large ERP and CRM suites. Although these applications were meant to have self-contained data models, it turns out that many enterprises still need to manage “master data” between the various applications. So the traditional IT role of hardware administration and custom programming has evolved to packaged application implementation and large scale data management.  According to Wikipedia: “MDM has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting and distributing...

Electronic Trading Systems Moving to the Cloud

More and more business applications are moving from the desktop to the cloud, and electronic trading applications are no different. Over the last five or ten years, application vendors have established several advantages of running major applications, even mission-critical applications like salesforce.com, over the cloud. These advantages include: Easier and smoother upgrades, which provides much better adaptability and agility in the face of changing market and business conditions, plus a better user experience, Better scalability, with newer technology advances, and Better portability across a wide array of device...