Explain Process flow in data warehouse??
Answer / parvar
1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house
| Is This Answer Correct ? | 2 Yes | 0 No |
Is there any difference in testing database and data ware housing?
How to generate the cubes in framework manager?
What is a core dimension?
How to add a number to a macro variable?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Can we start and stop single session in concurent bstch?
if you use oracle sql*loader , how do you transform data with it during loading?
What is up date strategy and what are th options for update strategy?
Which are the olap tools available that are supported by oracle?
What are the steps involved in creating dimensional modeling process?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How to load the time dimension?