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 are the steps to build the data warehouse?


Category Data Warehousing Basics Interview Questions
Rating (3.3) By 3 users
Added on 7/26/2006
Views 1383
Rate it!
Answers:

As far I know...<br><br>Gathering bussiness requiremnts<br>Identifying Sources<br>Identifying Facts<br>Defining Dimensions<br>Define Attribues<br>Redefine Dimensions & Attributes<br>Organise Attribute Hierarchy & Define Relationship<br>Assign Unique Identifiers<br>Additional convetions:Cardinality/Adding ratios<br>



Gather requirements,<br>Identify Source tables,<br>Identify Destination tables,<br>Data modelling<br>Source to target matrix preparation,<br>ETL flow preparation and scheduling,<br>Reporting



 Posted by: sumati    

Contact sumati  Contact sumati


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 the datatype of the surrogate key?

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/8121/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.7