Interested to Buy Any Domain ? << Click Here >> for more details...
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
- 1 Answers
- 4285 Views
- I also Faced
- E-Mail Answers
Answer / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is level based metrics.how will you create it?
How online/offline mode impact development and delpoyment?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Define pipeline. Did you use it in your projects?
How will you go about adding additional column to the repository in the presentation layer?
what is guided navigation?
How do you implement security using External Tables and LDAP?
What is the difference between Data Level Security and Object Level Security?
What is scd type 1 and 2.
How do you define the relationship between facts and dimensions in BMM layer?
What is star schema and snowflake schema?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
Teradata 
