what is the difference between aggregate table and fact
table ? how do you load these two tables ?

Answer Posted / azhar

hi,

The difference might be in the granularity level....

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whether dimension table can have numeric value?

606


Give some difference between oltp and olap.

597


Explain what is the difference between datawarehouse and bi?

530


What are the methodologies of data warehousing?

574


Is there any rownum object from which we can do this?

522






What is the difference between aggregate table and materialized view?

598


How can you implement many relations in star schema model?

554


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

509


How do you setup Lo-cockpit?

2634


What are the various tools? Explain name a few?

538


What is data warehosuing hierarchy?

583


Suppose we want to display zero when null values coming to report how can we do that?

533


Who needs data warehousing?

562


What are the data types present in bo? What happens if we implement view in the designer n report?

547


What is the difference between snowflake and star schema?

585