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...
Expert Oracle book free download
The 2nd best Oracle book ever is now available for free download from the fine folks at allthingsoracle.com . http://www.red-gate.com/products/oracle-development/entrypage/expert-oracle-database-architecture Of course, the #1 oracle database book is “Expert Oracle one-on-one” by Tom Kyte. Her’s a link to the signature edition. http://www.amazon.com/Signature-Programming-Techniques-Solutions-One-On-One/dp/1590595254/ Download while it’s still available!
Extending functionality using Command Tasks : Informatica.
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...
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...
(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...
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...
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...
Informatica : Unexpected Condition in file relwrtconn.cpp
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...
Workflow dependency in Informatica: Part-2 : Load Status Entries
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...
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...
Recent Comments