ORA-01403: no data found

August 9, 2012

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...

Read more »

Extending functionality using Command Tasks : Informatica.

December 21, 2011
Informatica Command Task

Martin posted an interesting question in the comments section here. It belongs to a common class of questions about how we can add abilities such as file handling, processing, and similar tasks in informatica, so I decided to extend the discussion into a post in itself. This post explains how you can use Informatica’s...

Read more »

Email task, Session and Workflow notification : Informatica

December 21, 2011
Informatica Email Task

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...

Read more »

(When to use ) Unconnected LookUp in Informatica.

August 15, 2011
(When to use ) Unconnected LookUp in Informatica.

One of the readers posted the following question, which is another frequently asked Question in Informatica What is the absolute necessity of Unconnected lookup, if same functinality can be achived by Connected Lookup Transformation. Please post some real time situations where we decide either to use Connected/Unconnected Lookup Tranformation. The main advantage of using...

Read more »

Informatica Workflow Successful : No Data in target !

June 11, 2011

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...

Read more »

Toad : User Files Location

May 26, 2011
Toad : User Files Location

All the temporary files that you are currently working on are stored at: C:\Documents and Settings\username\Application Data\Quest Software\Toad for Oracle\version\User Files I always have trouble remembering this location . It only comes up automatically during Start up only if you exit toad with an error or if it Crashes for some reason. Posting it...

Read more »

Informatica : Unexpected Condition in file relwrtconn.cpp

May 9, 2011

I got this “fatal” error when I was running one of my sessions today wich was using a parameter file. I am currently running on 8.1.1 SP3 and this does not happen in 8.5+ anymore… *********** FATAL ERROR : Unexpected Condition in file line . Contact Informatica Technical Support for assistance. Aborting this...

Read more »

Workflow dependency in Informatica: Part-2 : Load Status Entries

April 26, 2011

This post is a continuation of the first part here and explains how to deal with workflow dependencies in Informatica using Load Status entries. I have listed out the limitations with using event wait files here. Note : this example and scripts are for Informatica running on Oracle and Unix (ksh). You can of...

Read more »

Getting started with Informatica PowerCenter

March 10, 2011
Getting started with Informatica PowerCenter

One of the readers posted a comment as to how to get started with the Informatica Power Center. I’ve seen it asked a lot of times and I hope to answer it here. If I have missed anything, kindly comment below and I’ll update the post as needed. How to get Started Understand SQL...

Read more »

Informatica : Error threshold for each session

January 22, 2011
Informatica : Error threshold for each session

This article explains how you can set the Error threshold for a given session in Informatica. This is based on a few posts I made here on a discussion thread. The default value for this parameter is “0″ (Zero) which indicates unlimited non-fatal errors allowed. The session will “succeed” even if all the rows...

Read more »

Page 1 of 2
1 2