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
- 2 Answers
- 6417 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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What Is The Difference Between Oltp And Olap?
What we need to discuss with designer before starting the universe designing.
Explain what task is 98% of the required work of a business analyst?
what is universe null
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain how to schedule the report in b.o?
how get the grand total in master-detail report?
Can we create universe with no cache??
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain in detail about type 1?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is difference between custom hierarchy and report based hierarchy?
