Would you recommend using an orderby clause as part of a lookup sql override for a cached lookup data set in informatica

  • Interview Candidate
  • 6
  • 2043

Showing Answers 1 - 6 of 6 Answers

chandrarekha

  • Sep 24th, 2007
 

No ,It decreses the performance

  Was this answer useful?  Yes

vemurisasidhar

  • Sep 26th, 2007
 

if u use order by clause in the lookup it improves the performance. because system generated order by consists all the lookup ports in the orderby clause. instood use ur own order by clause. so that the input data can be sorted by the way u like

ex. order by deptno--

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions