Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?



Does aggregate and fact tables gets populated from transactional data with only diffrence in there ..

Answer / pratap

Th Aggregate tables will always have higher granularity than the fact table. The grain of aggregate table can be derived from one key or combination of multiple keys from within the fact table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

a __________ is a virtual table made up of subset of actual table

2 Answers  


what is the full procedure for using store procedure in informatica7.1?

0 Answers  


What is global database name?

0 Answers  


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

0 Answers   HP,


How do you connect to a database?

0 Answers  






please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

0 Answers  


WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

0 Answers  


What are different types of resources?

0 Answers  


Is storing images in a database a good idea?

0 Answers  


What is the use of default key?

0 Answers   Abacus,


How many types of locks are present in a database?

0 Answers   Abacus,


what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,






Categories