What is the difference between a W/H and an OLTP application?
Answer Posted / guest
Ware house: Query reporting & analysis tool.
OLTP: For analysis purpose.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
Explain what is batch and describe about types of batches?
Start a batches with in a batch?
What is the difference between Datawarehouse and OLAP?
What is recovering sessions?
Explain about core dimension,
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
what are different storage options supported by oracle ?
Explain me what are data marts?
How do we design a universe?
What is the data type of the surrogate key?
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?
Explain what is a view as it relates to system modeling?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Code the tables statement to produce a multi-level frequency?
Explain which columns go to the fact table and which columns go the dimension table?