Wednesday, 28 September 2016

Overriding Default Sorting in Informatica Lookup Transformation

Informatica adds the default order by clause for all ports present in the lookup condition. If you need to override the Order By clause, just put the SQL comment sign at the end of query. 

e.g. Select a, b, c, d from table order by b, c, a, d -- 

and ports b and c are present in lookup condition in that order, the query Informatica will generate will then be 
Select a, b, c, d from table order by b, c, a, d -- order by b, c 

Here because of your comment sign, the order by clause added by Infa will get commented out.

No comments:

Post a Comment