WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
- 4 Answers
- 10633 Views
- Ericsson, Nokia, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hemanth
The situation leads to data inconsistency in reports so
there have to a lot of work round to resolve issues with
data. It leads to TRAPS, which might demands contexts,
specify data fetch tables and more based on business
requirement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / dipti
If your universe has multiple star schema, having more than
1 fact table is natural. The issue, however, is when we
have more than 1 fact table in one star schema formation.
This is because, that would lead to fact to fact join -
which is normally manay to many cardinality join. For more
details and to understand the concepts, read this:
http://www.dwbiconcepts.com/reporting-a-analysis/25-
business-objects/114-top-businessobjects-interview-
questions.html
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / hemanth
The situation leads to data inconsistency in reports so
there have to a lot of work round to resolve issues with
data. It leads to TRAPS, which might demands contexts,
specify data fetch tables and more based on business
requirement.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / guru
If your universe has multiple star schema, having more than
1 fact table is natural. The issue, however, is when we
have more than 1 fact table in one star schema formation
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan
HOW DO YOU SCHEDULE THE REPORTS?
What is detailed Object
1.what is context? How u create? With example.
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...
What services the broadcast agent offers on the server side?
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What is the difference b/w the simple Universe and Complex Universe?
what are slowly changing dimensions, confirm dimensions?
What is object stores?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
Teradata 
