GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 45 of 65    Print  
What is the Difference between a ODS and Staging Area

  
Total Answers and Comments: 3 Last Update: January 10, 2009     Asked by: nagireddy 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: mithunmca
 
 ODS :-Operational Data Store which contains data .
           ods comes after the staging area
eg:-
       In  our e.g lets consider that we have day level Granularity in the OLTP & Year level Granularity in the Data warehouse.
        If  the business(manager) asks for  week level Granularity then we have to go to the oltp and summarize  the day level to the week level which would be pain taking.So wat we do is that we maintain  week level Granularity in the ods for the data,for  abt  30 to 90 days.

Note : Ods information would contain cleansed data only. ie after staging area

Staging Area :-
                        It comes after the etl has finished.Staging Area consists of
                        1.Meta Data .
                        2.The  work area where we apply our complex business rules.
                        3.Hold the data and do calculations.
In other words we can say that its a temp work area.



Above answer was rated as good by the following members:
flodhi10
March 28, 2007 07:45:15   #1  
mithunmca Member Since: January 2007   Contribution: 7    

RE: What is the Difference between a ODS and Staging A...
ODS :-Operational Data Store which contains data .
ods comes after the staging area
eg:-
In our e.g lets consider that we have day level Granularity in the OLTP & Year level Granularity in the Data warehouse.
If the business(manager) asks for week level Granularity then we have to go to the oltp and summarize the day level to the week level which would be pain taking.So wat we do is that we maintain week level Granularity in the ods for the data for abt 30 to 90 days.

Note : Ods information would contain cleansed data only. ie after staging area

Staging Area :-
It comes after the etl has finished.Staging Area consists of
1.Meta Data .
2.The work area where we apply our complex business rules.
3.Hold the data and do calculations.
In other words we can say that its a temp work area.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 1Overall Rating: -N/A-    
August 09, 2007 04:33:42   #2  
siraj khan        

RE: What is the Difference between a ODS and Staging A...

The full form of ODS is Operational Data Store.ODS is a layer between the source and target databases..ODS is used to store the recent data.

Staging layer is also a layer between the source and target databases..Staging layer is used for cleansing purpose and store the data periodically.


 
Is this answer useful? Yes | No
January 09, 2009 21:31:37   #3  
Vamshidhar Member Since: February 2008   Contribution: 4    

What is the Difference between a ODS and Staging Area
ODS (Operational Data Source) is the first point in the Datawarehouse. Its store the real time data of daily transactions as the first instance of Date.

Staging Area is the later part which comes after the ODS. Here the Data is cleansed and temporarily stored before loaded into the Datawarehouse.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape