how can one connect two fact tables ? is it possible ? how?
Answer Posted / dinesh
Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Do you view contain data?
Explain what is the difference between view filter and report filter?
how much memory space occupied real time project (roughly)?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
How to handle multi value dimensions?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain what is cost benefit analysis (cba)?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Explain meta data?
What is the difference between dependent data warehouse and independent data warehouse?
Compare aggregates and data marts
How can you clear the cache?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?