GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Data Integration

 Print  |  
Question:  What is the difference between lookup(0 and lookup_ext()..

Answer: What is the difference between lookup(0 and lookup_ext() functions in BODI?


February 02, 2008 06:05:46 #1
 gssharma_msc Database Expert  Member Since: January 2007    Total Comments: 4 

RE: What is the difference between lookup(0 and lookup_ext()..
 

lookup() - It will compare only single coloumn and return only single port
Where as
lookup_ext() - will compare multiple columns and return multiple rows

     

 

Back To Question