In general, how many Fact & Dimension tables are present in
a Banking Data warehouse project ?



In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?..

Answer / Rupesh Kumar Singh

The number of Fact and Dimension tables in a Banking Data Warehouse project can vary greatly depending on the specific needs of the business. However, a typical Data Warehouse model would have multiple Fact tables (which store measures or facts) and several Dimension tables (which store attributes or dimensions).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What does level of granularity of a fact table signify?

1 Answers  


1.WHAT IS DATA MART ?

5 Answers   HCL,


What is confirmed dimension?

7 Answers   JPMorgan Chase,


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1 Answers  


what are the major three types of modeling used?

1 Answers   InfoAxon Technologies,


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1 Answers   L&T,


Explain what are slowly changing dimensions?

1 Answers  


What is the difference between ods and oltp?

1 Answers  


What is cost benefit analysis (cba)?

1 Answers  


What are the stages that are required in data warehousing?

1 Answers  


If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,


What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1 Answers  


Categories