Wednesday, October 04, 2006
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
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
