Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37667 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
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
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Ist the schema that a data warehouse system can implements.
Define data warehouse?
What is is a star schema?
what are the major three types of modeling used?
What is dimensional modelling?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the main difference between inmon and kimball philosophies of data warehousing?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are aggregate tables and aggregate fact tables?
Explain the differences between normalizer and normalizer transformation?
Explain what are the various file formats involved in reportnet?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is partitioning? What are the types of partitioning?
What is the difference between olap and oltp?
