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

Answer Posted / plaban

The main difference is the type of involvement in Schema

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data warehouse architecture?

742


How to import vsam files from source to target. Do we need a special plugin?

686


What is analytical or analytic mean?

828


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

670


Explain difference between data ware house & data mart?

695






Explain what is a three tier data warehouse?

702


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

702


What are the different types of schemas used in data warehousing?

692


Can you brief about the Data warehouse project you worked on?

2108


What are the advantages of raid 1, 1/0, and

717


What are the other names given to data warehousing?

821


What are Aggregate tables?

863


What are necessary tasks to install reportnet software?

682


What is a source qualifier?

753


Explain what is data validation strategies for data mart validation after loading process?

777