Answer Posted / zg
Cardinality is applicable on both entity and attribute levels.
Attribute Level : GENDER[MALE,FEMALE] - cardinality 2
Entity Level: CUSTOMER[HOME ADDRESS, MAILING ADDRESS,
SHIPPING ADDRESS, BILLING ADDRESS] cardinality (1,4)
Customer has 1 to 4 addresses
CUSTOMERS[ORDERS] cardinality (0,N)
Customer may have zero or more orders
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain how many universes can be created in a project?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain what three things do you consider to be the most important factors for a manager?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain in detail about type 1?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what are the tables used in health care domain project and columns used in report?
What is Indexing? how did u implement indexing?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
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?
