1 Answer - Sort by: Date | Rating
When you mean process things in a data warehouse I'm assuming you are asking how does data move from one stage of a data warehouse to the other. The most conventional flow of information in a data warehouse will look something like this:
Transaction System - Pre-Staging - Staging - Data warehouse/Data mart - Analytical processing
There is a chance that data could move directly from the Transaction system to the data warehouse. This normally happens in the case of flat files. There are a number of tools that are used in the entire process. The Transaction system could be SAP while a TIBCO integrator can be used. Informatica could be used for the ETL process while there is on offer an entire gamut of reporting tools in the market.
The movement of data in the data warehouse will solely depend on the requirements specified by the client as he is the one who is paying for everything.
Transaction System - Pre-Staging - Staging - Data warehouse/Data mart - Analytical processing
There is a chance that data could move directly from the Transaction system to the data warehouse. This normally happens in the case of flat files. There are a number of tools that are used in the entire process. The Transaction system could be SAP while a TIBCO integrator can be used. Informatica could be used for the ETL process while there is on offer an entire gamut of reporting tools in the market.
The movement of data in the data warehouse will solely depend on the requirements specified by the client as he is the one who is paying for everything.
0
0
- What Are The Top Ten Colleges/universities To Go To With A Career As A Buyer?
- You Are In Charge Of Promoting A New Flavour Of Tooth Paste Yet To Be Produced In A Tooth Paste Manufacturing Unit,?
- What Are The Basic Under Job Discription?
- Explain The Interrelationship Between Environment Factors And How Each One Influences The Other?
- How To Write A Letter To College For Requested Diploma?
- What Are The Classifications Of Hormones?detailed Information
- What Is Last Date Of 10 Class Admission?
- What Are The Significance Of Contract In Terms Of Legality And Validity?
- How To Calculate Percentage Reduction Of Wire Drawing M/c?
- What Is The Table Of Solutions For The Equation Y=3x+2?
- How Has Sytematic Counselling Shape The Councellor?
- List Of Pnpa Examination Last October 25,2009?
- What Are Three Basic Inconsistencies Of Wealth Maximization And Profit Maximization?
- What Is The Scope Of Gender And Women Studies?
- When Will Supplementary Examination Held From Secondary Education Of Karachi?
- The Amount Of Interest Of An Ordinary Annuity Of $11600 For 5 Years At 8% Compounded Semi Annually Is?
- I Need To Know An Experiment (for A Science Project) That Will Take About 15-30 Minutes To Do NOT Including Take Down And Set Up. That (heres The Important Part) Is On Metamorphic Rocks. Thanks. :)?
- Where Can I Get Fre Dsipoints?
- How Do I Write A Letter To Immigration Concerning A Relationship Between My Friend And Her Boyfriend?
- Are The Three Key Principles Of Conversation? Explain How They Can Apply In Your Conversation
- How To Write A Letter For Compassionate Leave?
- How To Box Amatuer?
- Where Can I Find Accelerated Reader Quiz Answers For The True Confessions Of Charlotte Doyle?
- Where Can I Find Accelerated Reader Quiz Answers?
- How Many Entrance Exams Are There After 12th Science Stream And Which Are They?
Featured Question
New Comment - Comments are editable for 5 min.