how to link 3 fact tables



how to link 3 fact tables..

Answer / joel rodrigues

Fact tables are tables with lots of measure values and are
uniquly identified by a key, also a fact table can have a
foreign key. For Example custumer fact table is connected
to loan fact table via customer_id, and each record in loan
fact table is uniquely identified by a primary key on
cod_acct_no. Similarly customer table can be connected to
Savings fact table through customer id.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Business Objects Interview Questions

What is scope of analysis ?

3 Answers   L&T,


Why do we need metrics and sets?

1 Answers  


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

0 Answers  


main purpose of aggregate awareness(not include make possible of use of aggregate tables)

2 Answers   Accenture,


How can you first report in Business Objects by using broadcast agent?

0 Answers   Ness Technologies, Wipro,






What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,


What is the report extension in webi and deski

2 Answers  


1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  


What is difference between merged dimension and forced dimension??

1 Answers  


What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,


what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,


What is DSS?? (Defination of DSS)

2 Answers  


Categories