solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 7086 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kapil
To solve this loop, we should crate two context each for
one fact table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / gs2kumar@gmail.com
Assume fact tables as F1, F2 and dimensions are D1, D2.
D1--<F1>--D2--<F2>--D1 like this we can connect, here loop and traps also will occurs. To resolve we can use context.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / riaz
link like......
dimension table TO 2 fact table1s
this is called "CONFORMED DIMENSION"
dimension table which is connected to multiple fact tables
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / satya
By creating alias table for one dimension, we can resolve
the loop
| Is This Answer Correct ? | 0 Yes | 4 No |
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
how to create a derived table in designer? i need steps regarding derived table
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
what are the complex reports you have created. Tell me with example?
What is the difference between derived table and views? which one gives better performance?
How to create predefined filters in B.O.
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
while migrate bo 5.1 report into boxir2 ,what are the problems faced
What is mean by tuning the report?
How to schedule the report in b.o?
Hi, How to navigate one report to another report in webi? Thanks in Advance
Teradata 
