Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10717 Views
- I also Faced
- E-Mail Answers
Answer Posted / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 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 the difference between view materialized view and view?
I have two universes created by two difference database can we join them in designer & report level? How
What are algorithms provided by Microsoft in SQL Server?
What is your spectra photometer working principles?
Where the applications and where ware house management system is used?
What needs to be done when the database is shutdown?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
what are the different views that are considered when building an object-oriented software system?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what is the difference between view filter and report filter?
What is pre-emptive and non-pre-emptive?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is the metadata extension?
What is the data type of the surrogate key?
