Series: Subject: Topic:
Question: 241 of 1135

SQL Override and Lookup Override

What is the difference between SQL Override and Lookup Override
Asked by: purushotham.dwh | Member Since Apr-2008 | Asked on: Apr 6th, 2008

View all questions by purushotham.dwh

Showing Answers 1 - 2 of 2 Answers

Answered On : Jul 26th, 2008

View all answers by Mamta11

If you write a SQL override in lookup transformation its a lookup override.

Login to rate this answer.

Answered On : Oct 13th, 2008

View all answers by raj_infadev

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 it3. SQL Override can provide any kind of join by writing the query    Lookup Override provides only Non-Equi joins4. 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....RegardsRaj

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.