Answer Posted / chandrasekar
Staging area is a nothing but storage area or parking area
to store the multiple source date. It will
transform,combine, cleanse data,do the simple business logic
and prepare the source data for datawarehouse.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you import tables from a database?
Explain the hierarchies level data warehousing.
Why should you put your data warehouse on a different system than your oltp system?
How can you clear the cache?
Explain normalization?
What are the stages that are required in data warehousing?
How much data hold in one universe.
What are vaious etl tools in the market?
What is your spectra photometer working principles?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
what are the other factors of the database on which the loading performance depend?
What should I have in mind when building olap solution from scratch?
What are situations where snowflake schema is better than star schema when the opposite is true?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?