what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / santosh
The difference that i know is that the aggregate tables
contain only the summaries of the data where as the fact
tables contain summaries and measures. i.e.,the grain of
the data present in fact table is more than the grain of
the data present in aggregate tables.
Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
How many project sources we can create in metadata?
What is data stream and data adaopter?
Explain how many ways you create ports?
What needs to be done while starting the database?
What are the key features of chameleon that separates it from other algorithms?
What are diagrams?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
How can you set the session management?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
How can we run the graph? How can we schedule the graph in unix?
Explain er diagram?
Explain me what is vldb?
Explain how are the dimension tables designed?
What is vldb(very large databases)?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?