SQL Override and Lookup Override

What is the difference between SQL Override and Lookup Override

Questions by purushotham.dwh

Showing Answers 1 - 2 of 2 Answers

raj_infadev

  • Oct 13th, 2008
 

Obviously we have some differences between those 2 Overrides...

1. SQL Override is to limit the number of incoming rows entering the mapping pipeline
    Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time & cache it uses...

2. Lookup Override uses "Order By" clause by default
    SQL Override doesn't uses it & should provide in our query if we require it

3. SQL Override can provide any kind of join by writing the query
    Lookup Override provides only Non-Equi joins

4. Lookup Override gives only one record even if it finds multiple records for a single condition
    SQL Override doen't do that...

Let me know if m wrong in any point....

Regards
Raj

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions