solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 6440 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 |
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is DSS?? (Defination of DSS)
what are the disadvantages of alias?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
why less number of records in loop? why more number of records in traps?
it is possible to link two universes of separate functional domain ?
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
How to get two dimension objects in a same block which are comming from two different contexts ?
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
What is the difference between user and versatile user?
How would you format some text using css to be verdana and bold?
Teradata 
