what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / nethaji
fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Explain what are data marts?
Explain what are the different types of join operations?
What is dimensional modelling?
What is the use of dimensional modeling in data warehousing?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Explain what are the various file formats involved in reportnet?
Explain what is real time data-warehousing?
What we will do with the universe for faster process?
What are the differences between star and snowflake schema?
Explain when do we analyze the tables? How do we do it?
Can you pass sql queries in filter transformation?
What are the different types of join operations?
Explain what are the methodologies of data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
How do you setup Lo-cockpit?