how can one connect two fact tables ? is it possible ? how?
Answer Posted / raj
Fact Tables are connected by confirmed dimensions, Fact
tables cannot be connected directly, so means of dimension
we can connect
| Is This Answer Correct ? | 12 Yes | 8 No |
Post New Answer View All Answers
How to design file watch jobs?
Which columns go to the fact table and which columns go the dimension table?
How to handle multi value dimensions?
What are loops in Datawarehousing?
What is data analytics in simple terms?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are universe requirements?
Explain what are components of reportnet?
What is the difference between metadata and data dictionary?
What are necessary tasks to install reportnet software?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are aggregate tables and aggregate fact tables?
Explain what is the advantages data mining over traditional approaches?
in general which algorithms for used?
How to create diff. Types of templates?