GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 45 of 113    Print  

1.what is incremental loading?
2.what is batch processing?
3.what is cross reference table?
4.what is aggregate fact table

  
Total Answers and Comments: 3 Last Update: December 19, 2008     Asked by: usha 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 07, 2005 01:34:45   #1  
senkumar79 Member Since: October 2005   Contribution: 17    

RE: 1.what is incremintal loading?2.what i...

Incremental loading means loading the ongoing changes in the OLTP.

Aggregate table contains the [measure] values aggregated /grouped/summed up to some level of hirarchy.


 
Is this answer useful? Yes | No
December 07, 2007 08:17:39   #2  
Sivakumar.R Member Since: December 2007   Contribution: 14    

RE: 1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table

let we explain these stuff like these... for eg you are working on universe it has n numbers of universe/classes/derived table.let we say these interms of objects.right now iam having 10 object(may be measure/dim/detail object what ever it may have).suppose i have created one object since now we have 11 object in the universe.if i export only the newly created object means it is called Incremental Loading or else when i export 10+1(newobjects) means that is normally export we doing always.


 
Is this answer useful? Yes | No
December 19, 2008 03:41:09   #3  
mri_sonam Member Since: July 2008   Contribution: 19    

RE: 1.what is incremental loading?2.what is batch processing?3.what is cross reference table?4.what is aggregate fact table
Incremental Loading:
Its also called retrospective data load.In this data being loaded on a regular inerval and only new data is moved.
eg in ur data warehouse ur loading "Transactional Data" on daily basis and its happning only for new Transactions because old Data is already in the Data warehouse.
Batch Processing:
Its processing of Jobs/Task together.
eg if u have a staging area u may have valid reason to get data for different Departments there first and then move all that in one shot to production.

 
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