Answer Posted / amar bandhu
ODS(Operational Data Store) - This has a broad enterprise
wide scope, but unlike the real entertprise data warehouse,
data is refreshed in near real time and used for routine
business activity.
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain how to export mappings to the production environment?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is Operational Data Store?
What is "method/1"?
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 the function of surrogate key in data warehousing?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is data stream and data adaopter?
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 347 what is hybrid slowly changing dimension?
How can you import tables from a database?
For faster process, what we will do with the universe?
What is surrogate key? Where we use it? Explain with examples.
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain hybrid slowly changing dimension?