Data Warehouse and Data Integration

Knowledge Sharing on Informatica
1. How to change the default order by clause in Lookup Transformation

Answer: Informatica by default add the order by clause in lookup Query. To over write the default query , add "--" at the end of the lookup overide query. This means that Informatica will add "ORDER BY " Clause at the end of SQL overide but will be treated as commented statemanet beacuse of --.

Any further question, send EMAIL at arvind.pushpam@gmail.com