My First Half-Marathon ...

After such a hectic practice session; it was an awesome experience to actually run the HALF-MARATHON.  The first thing in mind was to complete the race and had set a target of 2:30:00 for the same.  Was super excited when found out that I actually did complete the race and that too in 2:22:21.  Hopefully this is just the beginning of many more runs to follow.

INFORMATICA

• In Informatica 9.x, if you need the lookup transformation to return multiple values, when creating the looup, you have the option at the bottom of the window that needs to be checked -- "Return All Values on Multiple Match". If not selected, a regular lookup will be created and you would not be able to select the option later on
• In a lookup transformation, if the need be to use the latest value from the lookup table AND if the condition port has >= OR <= comparision, make sure that there is a lookup override which has ORDER by clause with ASCENDING order and in lookup properties select -- "Use Last Value". Do not try Descending order and try to set the property to "Use First Value". Would not work. Informatica defaults the Order By to Ascending in this case.