Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
- 4 Answers
- 11995 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 |
I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
How do you find what type of trap is there by seeing the report?
Explain what three things do you consider to be the most important factors for a manager?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
what are the complex reports you have created. Tell me with example?
How can we acheive Correlated sub-query in Designer?
2 Answers Infosys, TCCX, Wells Fargo,
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
Teradata 
