One of the frequently asked questions in Informatica is the difference between connected and unconnected Transformation. The way to differentiate between the two is rather simple. Take a look at the mapping and see if they are “connected” to the…
Monthly Archives: December 2010
Informatica : Multiple Targets based on Source Order.
by Rajesh • • 11 Comments
One of the frequently asked questions on the Informatica forums at Informatica forums is how to load data into different target tables based on the order of the source row data. Eg..If you have an employee table that has 14…
Informatica – Exp/Query editor missing (Dual Monitor issue)
by Rajesh • • 26 Comments
If you happen to be one of those developers who use dual Monitors at work ,here is a problem that might drive you crazy It is surprising that it hasn’t been fixed (atleast as of version 8.6.1), considering the widespread…
Informatica – Loading a Flat File into a target Database
by Rajesh • • 17 Comments
Loading data from a Flat File into the database is a frequent task for all Database/data warehouse developers. This article details how to do the same using Informatica Powercenter. Table Creation and Source File. The following is the script I…
Informatica — Lookup Transformation (“Use any value”)!
by Rajesh • • 12 Comments
For those of you who have limited/no Informatica Power Center experience before, this is one of the options you can select when you use a look up transformation in your mapping. I’ll first explain the background as to why this…
Informatica Unable to fetch log
by Rajesh • • 8 Comments
Quite often, you might come across the following error when you try to get the session log for your session.
1 2 |
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…