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

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions