GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL

 Print  |  
Question:  Extract / Transform Process

Answer: Describe the stages of extract / transform process, including what should happen at each stage and in what order?


August 08, 2009 02:20:38 #4
 sagarw9   Member Since: August 2009    Total Comments: 1 

RE: Extract / Transform Process
 

In the extract process, we extract the data from the different sources like data files, flat files, etc.. into the stagging area or we can say input area for the further processing.
Once get files in the input, data is applied for the processing by applying some business logics to meet the requirements.
After processing data, it is loaded into the target locations.

     

 

Back To Question