GeekInterview.com
Series: Subject: Topic:
Question: 85 of 129


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

Asked by: Interview Candidate | Asked on: Sep 15th, 2005
Showing Answers 1 - 4 of 4 Answers

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.

  
Login to rate this answer.

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.

  
Login to rate this answer.
mri_sonam

Answered On : Dec 19th, 2008

View all answers by mri_sonam

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.

  
Login to rate this answer.
Andrey Parkhomets

Answered On : Feb 27th, 2012

cross reference table used to describe many-2-many relation between tables.

aggregate fact table - when granularity of fact data not required fact can be grouped over dimensions, measures will be affected as sum(measure) or over aggregated functions.

Despite aggregation in the fact the drill-down possible into initial detail fact (raw fact) data using vice-verse of aggregation logic.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.