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
- 2 Answers
- 5544 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between business requirement document and use case document.
Explain which versions are used in the bo dashboard work?
What Is Snow Flake Schema?
Explain is data mart?
U r project in which stage in implementation?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what are the steps to be taken to schedule the report?
Explain in detail about type 1?
Can Bo generates the Report from the cubical data Explain?
What is object stores?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain when we use aggregate awareness function in designer?
Explain difference between zabo and webi?
What is difference between webi and infoview?
What are the join problems comes appart from loop,chasm & fan Traps
