Answer Posted / raji
Data warehouse is logical database,which is maintain
different mutlipule databases and stored historical data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the advantages data mining over traditional approaches?
Give some difference between oltp and olap.
Explain what is the data type of the surrogate key?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is the difference between connected and unconnected stored procedures?
What are the steps involved in designing a fact table?
Define Data Warehousing?
What is the use of dimensional modeling in data warehousing?
Can you pass sql queries in filter transformation?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
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 session timeout and application timeout?
In document how to create metrics?
what is difference between drill & scope of analysis?
What is drilling across?
