What is real-time datawarehousing?
What is the difference between snowflake and star schema?
Where we use surrogate key explain with example?
Explain the difference between view and materialized view?
What are components of report studio?
Explain what are the methodologies of data warehousing?
What is data mart in data warehouse?
What are the differences between star and snowflake schema?
Explain the difference between keylokup and joiner?
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 the others of "bad files" and "discard files" when using sql*loader?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How do we design a universe?
What is the advantages data mining over traditional approaches?
Explain what is type 2 version dimension?