What is the difference between lookup and join in SAP BODS?

Asked by Last Modified  

2 Answers

+1 Informatica

Follow 1
Answer

Please enter your answer

Dheeraj

IT Corporate Trainer with 9 years of experience in Edu tech

The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select...
read more
The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches). There are various aspects to the performace of both mechanisms, but you only need to be concerned with this if you have performace issues. read less
Comments
Dislike Bookmark

I am online Quran teacher 7 years

The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select...
read more
The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches). There are various aspects to the performace of both mechanisms, but you only need to be concerned with this if you have performace issues. read less
Comments
Dislike Bookmark

Related Questions

How to find which institute among the list trains good in SAP SD?
I am taking up the classes for SAP SD Training.
Viraat
0 0
8
What courses do you suggest for me? I'm an HR Manager for a IT recruitment firm & want to become Functional with SAP.
Hi SAP hcm abd success factor both would be a better platform for you both is having different importance.
Kim
How will career as Sap hana modeler be in future?
SAP HANA is the only course will give you an edge over other guys as HANA is the best Analytical tool by any company in market and for this you can ask even 100% hike from other companies...and this...
Bharath
0 0
5
Hi, I have experience of 2 years in Database technologies. Not from CS Background but interested in learning in either SAP or Informatica. I have to learn everything from scratch. Please help me find real time training and weekend classes as I am working. Also please let me know which all other courses have scope in future.
Hi Akash, As per the current market trends, Data Analytics has already started to take the market by storms and Informatica has emerged as one of the most sought after skills in the industry. There are...
Akash
1 0
5
I have completed B.com, MBA F&M and done SAP MM Consultant level training after 5 yrs of experience in SAP MM end-user, but I am not getting job opening for SAP MM Consultant fresher. Can anyone help to give a solution for getting entry in SAP MM fresher? Or suggest the best non-sap course with fresher job opportunities?
The best way is to share in a post on LinkedIn as that is the best professional network where you can easily explore jobs according to your requirements. Build as many connections as you can to reach recruiters with ease.
Priya

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

SAP Training
Dear Candidate, Please accept my greetings, SAP, It stands for Systems Applications and Products in Data processing. It’s German software and is being implemented in all companies from SME’s...
N

Netbusiness Solutions

0 0
0
Material Master Data
Material master: Storing the material related data into the database is called as material master data. In material master data, we can save the information for different views or different operations....

Ragunath

0 0
0
SAP MM Important T code
Here is the list fo some important t code usede in procure to pay cycle)P2P) in SAP MM. MM01 - Create MaterialMM02 - Change MaterialMM03 - Display MaterialMM04- Display material change documentMM06 -...

Sandeep Kajal

0 0
0
Procedure to Pay or P2P Process # SAP # AP
Procure to Pay or P2P Process # Business Process # SAP # AP ERP applications have simplified the Business Processes. In big companies, we have separate team for different business functions like Accounts...

Saurabh S.

0 0
0
SAP Analytics Cloud(SAC), or SAP Cloud Analytics
Hi All For all those who are currently working on SAP-BW,SAP-HANA,SAP-BO,SAP-Lumira,Design Studio,S/4HANA,BW/4HANA suggested to update SAP Analytics Cloud(SAC) a cloud version of BI from SAP Which is...

Bose

0 0
0

Recommended Articles

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find SAP Training near you
SAP Training in Bangalore
SAP Training in Hyderabad
SAP Training in Pune
SAP Training in Chennai
SAP Training in Mumbai
SAP Training in Delhi
SAP Training in Kolkata
SAP Training in Noida
SAP Training in Gurgaon
SAP Training in Ahmedabad
Online SAP Training

Looking for SAP Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you