INTERVIEW QUESTIONS
DATA WAREHOUSING
ETL
DETAILS
Question: What is a staging area? Do we need it? What is the purpose of a staging area?
Answer: Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps:
Source data extraction, Data transformation (restructuring),
Data transformation (data cleansing, value transformations),
Surrogate key assignments
Submitted by Minish Cherian ([email protected])
|
Question:
What is a staging area? Do we need it? What is the purpose of a staging area?
Answer:
Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps:
Source data extraction, Data transformation (restructuring),
Data transformation (data cleansing, value transformations),
Surrogate key assignments
Submitted by Minish Cherian ([email protected]) Source: CoolInterview.com
Staging is a temporary storage area where all data manupulation (cleansing, merging, scrubbing,..)takes place before loading into target dwh Source: CoolInterview.com
Answered by: Sandeep | Date: 4/7/2009
| Contact Sandeep
its temporary store in repository.but its can't change in data. Source: CoolInterview.com
Answered by: rajeshg | Date: 11/16/2009
| Contact rajeshg
remove duplications and repeated data Source: CoolInterview.com
Answered by: suneel kumar | Date: 1/18/2010
| Contact suneel kumar
Staging Area is temporary storage area in etl. It will do the cleansing,merging,profiling etc., Source: CoolInterview.com
Answered by: Karthikeyan | Date: 8/20/2010
| Contact Karthikeyan
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|