Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53616 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / surya
Aggregate tables also known as summary tables, are fact
tables which contain data that has been summarized up to
different level(Month level, year level) of detail
aggregation.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
After the complete generation of a report who will test the report and who will analyze it?
What are Aggregate tables?
Explain what are the various transformation available?
Is there any default username & pwd for bo designer & supervisor?
How many types of facts and what are they?
What is the 4 + 1 view model as it relates to system modeling?
What is data warehouse architecture?
Explain Association algorithm in Data mining?
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 reference cursor?
What are universe requirements?
How can you set the client management?
What are the possible data marts in retail sales?
Explain the data type of the surrogate key?
Explain what is difference between query studio and report studio?
