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.