Explain the difference between view and materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
Ist the schema that a data warehouse system can implements.
Explain the definition of normalized and denormalized view?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain what is power center repository?
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 are various warehousing tools?
What is staging area?
What is an OLTP (Online Transaction Processing) System?
What are the advantages of query studio compared to report studio?
What are parallel querys and query hints?
What is XMLA ?
What is difference between query studio and report studio?