0
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.
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.
0Awesome Comments!