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
What is the advantages data mining over traditional approaches?
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 ??????
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are the various transformation available?
What are loops in Datawarehousing?
What is cfapplication tag?
What are modeling tools available in the market?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is the 4 + 1 view model as it relates to system modeling?
What is VLDB?
What are the data types present in bo?
Explain degenerate dimension table?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Is there any rownum object from which we can do this?