Question

explain the process of designing the ETL.(extract transform load) Also explain the Designing of Staging areas...

explain the process of designing the ETL.(extract transform load)

Also explain the Designing of Staging areas and creating of mapping.

Also discuss in details Transformations in particular: STORE mapping, PRODUCT Mapping, and SALES cube mapping. and discuss the Features and Benefits of OWB.

Homework Answers

Answer #1

Answer : Given data

ETL Process :

* ETL is the process by which data is extracted from data sources (that are not optimized for analytics), and moved to a central host (which is).

* The exact steps in that process might differ from one ETL tool to the next, but the end result is the same.

* At its most basic, the ETL process encompasses data extraction, transformation, and loading.

* While the abbreviation implies a neat, three-step process – extract, transform, load – this simple definition doesn’t capture:

* The transportation of data

* The overlap between each of these stages

* How new technologies are changing this flow

_______________THE END___________________

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
explain the process of designing the ETL.(extract transform load) Also explain the Designing of Staging areas...
explain the process of designing the ETL.(extract transform load) Also explain the Designing of Staging areas and creating of mapping. Also discuss in details Transformations in particular: STORE mapping, PRODUCT Mapping, and SALES cube mapping. and discuss the Features and Benefits of OWB.
Analysis: This section should include the issue register as a bare minimum, but may include also...
Analysis: This section should include the issue register as a bare minimum, but may include also why-why diagrams, a Pareto chart, a waste table and/or value-added analysis table. Flow analysis or simulation of this case study might be possible but might require making a lot of assumptions given the provided data. The first part of the project: Introduction    Walmart has continued to retain the top position on the Fortune 500 list for a consecutive fifth year. The brand has...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...
1. Running On Carla Gomez is the owner of Running On—a retail store that sells shoes...
1. Running On Carla Gomez is the owner of Running On—a retail store that sells shoes and accessories to runners. Carla is trying to decide what she should do with her retail business and how committed she should be to her current target market. Carla started Running On retail store in 1994 when she was only 24 years old. At that time, she was a nationally ranked runner and felt that the growing interest in jogging offered real potential for...
Wal-Mart Online Wal-Mart is one of the largest companies in America. It is definitely the largest...
Wal-Mart Online Wal-Mart is one of the largest companies in America. It is definitely the largest retailer, both in terms of the number of stores (8,970 worldwide in 2011) and the level of sales ($419 billion from the 2011 Annual Report). By pushing suppliers to continually reduce costs, Wal-Mart is known for pursuing low prices and the stores often attract customers solely in-terested in lower prices. With Wal-Mart’s expansion into groceries, the company has be-come the largest retail grocer in...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules (Chapters 5 to 8). Its purpose is to provide you with experience in analyzing organizational information systems, making recommendations to improve these systems, and formulating a plan to execute on your recommendations. 1. Recommend one of your alternatives that is the best solution to the main issue and justify your recommendation. Your justification should be based on the key decision criteria and you must...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT