CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATA WAREHOUSING DATA WAREHOUSING BASICS DETAILS
Question :
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table


Category Data Warehousing Basics Interview Questions
Rating (3.0) By 2 users
Added on 7/26/2006
Views 2042
Rate it!
Answers:

Incremental loading means loading the ongoing changes in the OLTP.<br><br>Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hirarchy.<br>



Batch Processing means executing more than one session in single run at the same time. we can execute these session in 2 ways : <br>linear: exececuting one after another<br>parralel: executing more than one session at at time



 Posted by: srinivas rao telu    

Contact srinivas rao telu  Contact srinivas rao telu

Incremental loading means loading the data without any outage to the users who are using the database for reporting purpose.<br>Aggregate tables you can check in Net , it nothing but the aggregate of certain value from the fact tables in Star schema.<br><br>Batch processing is explained by |Srinivas Rao.



 Posted by: cooldude    

Contact cooldude  Contact cooldude


If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
What is meant by metadata in context of a Datawarehouse and how it is important?

View Answer
What is a linked cube?

View Answer
What is surrogate key ? where we use it explain with example.

View Answer
Wht r the data types present in bo?n wht happens if we implement view in the designer n report

View Answer
What is data validation strategies for data mart validation after loading process

View Answer
What is Data warehosuing Hierarchy?

View Answer
What is BUS Schema?


View Answer
What are the methodologies of Data Warehousing.

View Answer
What is conformed fact?

View Answer
What is Difference between E-R Modeling and Dimentional Modeling.

View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL Data Warehousing Basics Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/8139/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.69