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
- 53965 Views
- Target, I also Faced
- E-Mail Answers
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
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?
What is a hash cluster?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain how to get the first 100 rows from the flat file into the target?
What is the function of surrogate key in data warehousing?
Explain what are the advantages data mining over traditional approaches?
Explain what are necessary tasks to install reportnet software?
Explain what is the difference between datawarehouse and bi?
Explain the difference between data ware house & data mart?
What are snapshots? What are materialized views & where do we use them?
Explain the importance of data warehouse?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is latest version of power center / power mart?
What is is a star schema?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
