ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
Difference between ODS and Staging
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between ODS and Staging
Answer
# 1
An operational data store (ODS) is a type of database often 
used as an interim area for a data warehouse. Unlike a data 
warehouse, which contains static data, the contents of the 
ODS are updated through the course of business operations. 
An ODS is designed to quickly perform relatively simple 
queries on small amounts of data (such as finding the 
status of a customer order), rather than the complex 
queries on large amounts of data typical of the data 
warehouse. An ODS is similar to your short term memory in 
that it stores only very recent information; in comparison, 
the data warehouse is more like long term memory in that it 
stores relatively permanent information.

But in staging we are storing current as well as historic 
data. This data might be a raw and then need cleansing and 
transform  before load into datawarehouse.
 
Is This Answer Correct ?    6 Yes 1 No
Harshad
 
  Re: Difference between ODS and Staging
Answer
# 2
Operational Data store is a subject 
oriented,integrated,current,volatile collection of data 
used to support the tactical decision making process for 
the enterprise. It is the central point of data integration 
for busienss management,delivering a common view of 
enterprise data.
In Staging Area you are carried out ETL operations as per 
your business logic in order to fetch processed information 
into data ware house.
 
Is This Answer Correct ?    2 Yes 2 No
Pravin
 
 
 
  Re: Difference between ODS and Staging
Answer
# 3
1. ODS is close to the source. We can say it is a replica 
of source system.
While the staging area is a replica of the target DW.

2. The dimention and  fact will come into picture here in 
staging.

3. We are doing the Transformations in staging schema 
before loading it to the target.

4. We integrate different ODS source systems into the 
staging area and not in the ODS.
 
Is This Answer Correct ?    3 Yes 0 No
Kalpana
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
difference between bo 6.5 and bo xi r2 Accenture3
How can we do ETL process in SQL Server? ETL1
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.  1
When should one use an MD-database (multi-dimensional database) and not a relational one? IBM1
which automation tool is used in data warehouse testing?  1
What is META DATA information in Data warehousing projects? IBM1
what is parallelism?  1
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null. IBM1
What Oracle features can be used to optimize my Warehouse system?  1
What is XMLA ?  1
What are Fact tables and Dimension Tables? IBM2
where exactly in dataware house a confirmed dimension can be created Deloitte2
what are the types of dimension tables Infotech9
difference between For each and for all  1
three ways sql*loader could load data, what are those three types?  1
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K Accenture3
What is the difference between Oracle Express and Oracle Discoverer?  1
What is an OLTP (Online Transaction Processing) System?  3
what are different types of partitioning in oracle ?  2
What is Conceptual, Logical and Physical model?  1
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com