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
5511 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

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

0 Answers

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers

WHAT IS ROW LEVEL SECURITY IN BO?

7 Answers Wipro,

Can we create universe with no cache??

1 Answers

tell me about aggregate awareness in detail?

2 Answers Cap Gemini,

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers IBM,

What are the Errors in BO Pls Explain with Examples