Answer Posted / radhakrishnan vaithilingam
The staging area is used to travel the data between Source
sytem to Data wareshoue or datamart.
it should be important when we are extracting more than one
source sytem.
The staging will help us to do the cleansing and converting
the data to understaing the business team.
Bridge between source to data warehouse or Data mart.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data warehosuing hierarchy?
How to get the first 100 rows from the flat file into the target?
Explain multivalued dependency?
What is partitioning? What are the types of partitioning?
How we are using this function?
What are the different problems that ?Data mining? can solve?
List down some of the real time data-warehousing tools?
Compare and contrast aggregates & indexes
Explain what is full load & incremental or refresh load?
What are the main steps to build the data warehouse?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is data cleaning? How can we do that?
in general which algorithms for used?
What is a general purpose scheduling tool?
Explain what are the basic needs to join two sources in a source qualifier?