What are parallel querys and query hints?
What do you mean by static and local variable?
What are aggregate transformation?
What are the main steps to build the data warehouse?
What Oracle tools can be used to design and build a W/H?
Fact table is in normalized or de-normalized form?
what are different types of partitioning in oracle ?
What is a source qualifier?
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 Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Explain what does level of granularity of a fact table signify?
Explain what is the difference between olap and datawarehosue?
What is the difference between olap and oltp?