Answer Posted / sharma
A Staging area simplifies building summaries and general
warehouse management.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Whether dimension table can have numeric value?
Is there any rownum object from which we can do this?
What are the fundamental elements of the data warehouse?
What are aggregate tables and aggregate fact tables?
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 stages that are required in data warehousing?
What are the different types of scd's used in data warehousing?
Explain what are the mapping paramaters and maping variables?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is drilling across?
What is the difference between constraind base load ordering and target load plan?
What are the different types of data warehousing?
what are the others of "bad files" and "discard files" when using sql*loader?
What are Aggregate tables?