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

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

Question Posted / vinodkrishnamsetty

2 Answers
6506 Views
Hexaware, I also Faced
E-Mail Answers

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

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers IBM,

How to get the data from the two different sourcess

2 Answers IBM,

how do you give security to universe ?

2 Answers InfoStep, Tech Mahindra,

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers IBM,

Explain is there any other repository domains rather than universe, security, document?

0 Answers

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

5 Answers Cap Gemini,

Steps to create alias and apply

2 Answers

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers Patni,

What is meaning of fullpath client in business objects?

1 Answers Atiric Software,

What are the steps to be taken to schedule the report?

0 Answers

how to optimize the query perfomance in b.o?

1 Answers TCS,

For more Business Objects Interview Questions Click Here