Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10724 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rofali
In aggregate Fact tables data is aggregated at some level.
for example, we have a fact table for sales in which data
gets stored on daily basis. Now we can make another fact
table for sales which holds the sales data, aggregated at
weekly level. Now if we have to do repoting on weekly basis
we can directly use the aggregated fact table.this will be
the more efficient way.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
5.Explain ODS ?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
How do you setup Lo-cockpit?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
if you use oracle sql*loader , how do you transform data with it during loading?
what is difference between drill & scope of analysis?
Explain what is type 2 version dimension?
What is Bulk Insert?
Explain what are necessary tasks to install reportnet software?
What is Sequence clustering algorithm?
What is "method/1"?
Is it possible to have more than one row on the same table with the same foreign key?
Teradata 
