what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / tadikonda
Diff b/w two tables is performance.
Fact tables contains million of records and retriving the
records from fact table takes time.where as aggregate table
contains limited data from all the required tables,and we
retrive the data it takes less time.
Is This Answer Correct ? | 46 Yes | 10 No |
Post New Answer View All Answers
How many project sources we can create in metadata?
How do you define data block size?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the different types of segments?
How to create diff. Types of templates?
What is the difference between filter and lookup transformation?
Explain what are conformed dimensions?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what are the vaious etl tools in the market?
What is real-time datawarehousing?
Explain piconet?
Explain what are the advantages data mining over traditional approaches?
Explain what is full load & incremental or refresh load?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?