Here is a piece of sql I wrote recently to get the week ranges for a given set of dates. The two requirements that are different in this case are.. 1. The week starts on Monday. 2. The week number…
Author Archive for Rajesh
Work flow dependency in Informatica : Part-1 Event Wait Files
by Rajesh • • 12 Comments
This article explains managing basic work flow dependencies in Informatica using event wait files. I’ll explain why load status entries are a better suited implementation for complex scenarios and real applications and how you can simulate the same “event-wait” style…
Informatica and Self-Referential foreign keys
by Rajesh • • 1 Comment
There are always a few gotchas and bugs you’ll come across when you work with automatically generated code. Here’s one (Bug, in my opinion) that you’ll come across when you work with Informatica Power Center when your source table has…
(Modified) Oracle’s Scott Schema tables
by Rajesh • • 0 Comments
This is a modified version of Oracle’s Scott schema objects that I use at work to test out small scenarios and test cases. The only changes to the original schema are that the necessary foreign key constraints have been added…
Informatica – Connected vs Unconnected Transformation
by Rajesh • • 3 Comments
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…
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…