senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 7th, 2005

 

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.

Sivakumar.R

 Profile Answers by Sivakumar.R Questions by Sivakumar.R

• Dec 7th, 2007

 

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.

mri_sonam

 Profile Answers by mri_sonam 

• Dec 19th, 2008

 

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.

Andrey Parkhomets

• 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.

kamesh

• Jan 30th, 2018

 

Incremental loading is defined as the activity for only loading new records and updated records from a database into an established in a Quick view detect
Batch processing is the process of series of jobs without manual intervention.
A table which primary key is formed by the foreign key is called cross reference table i.e is many to many Relationship.