Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Tow tables is there employee, projects .
(many to many) one employee has different projects and one
project has different employees . how we can achive the data
from both

Answers were Sorted based on User's Feedback



Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / raja mahesh

Here a row in Employee table can have many matching rows in Projects table, and vice versa. You create such a relationship and can retrieve data by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table employee table and projects table.

Is This Answer Correct ?    9 Yes 0 No

Tow tables is there employee, projects . (many to many) one employee has different projects and one..

Answer / praveen

What kind of data(column) they need that not mentioned in
the question.

But, If they want data from both table we can use Join
comments by using primary key and forien key

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Business Objects Interview Questions

Tell me about linked universe ?

5 Answers   Tech Mahindra,


4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,


BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,


Hi any done business objects certification.i am expecting some help from them.

6 Answers  


I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,


Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  


normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,


Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

0 Answers   Arkema pte Ltd,


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

0 Answers   Wipro,


What is the difference between the prompt and cascading prompt

2 Answers  


5.what is LOV? where it is store?

3 Answers   TCS,


Categories