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
Answer Posted / 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 View All Answers
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain in detail about type 2(scd),
what are the tables used in health care domain project and columns used in report?
What Is The Difference Between Oltp And Olap?
Explain about a tricky situation for which you found a very simple solution?
What are the join problems comes appart from loop,chasm & fan Traps
Explain about alerts in bos, under what situation we need to use alerts?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What are the steps to do to use alerts in bo?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How many universes can be created in a project?
What is the difference between the public object&schema object?
Explain what task is 98% of the required work of a business analyst?
What is the profile and package?