Describe the etl process to retrieve the data and load it

Assignment Help Database Management System

Reference no: EM131158913

Describe a business problem that can be solved with Big Data solutions (structured and unstructured textual data, streaming or batch data, real-time or near real-time).

· List the analyses that are needed to solve the business problem.
· Identify what data is required to solve the problem, the volume of the data, the velocity of the data, the variety of data.
· Identify the legacy source systems to retrieve the required data. including the formats of the sources.
· Describe the data warehouse infrastructure to solve your business problem.
· Describe the ETL process to retrieve the data and load it
· Describe how the data would be integrated.
· Identify the metadata that would be useful to solve the problem.
· Describe the techniques to perform the analyses.

You should not implement the DW or include SQL.

Reference no: EM131158913

Questions Cloud

Correspondence in the massachusetts assembly : Who helped establish the Committee of Correspondence in the Massachusetts assembly?

What would be a good retirement : What are three social problems where the family in later life might help society? What might these programs do, and what challenges would they face? How do work and retirement impact a family in later life when pensions become less reliable and b..

Calculate the temperature change : Calculate the energy. Which substance in Table 6.1 has the largest temperature change when 550. g of the substance absorbs 10.7 kJ of energy? Calculate the temperature change.

British troops fired on a mob : What was the incident where British troops fired on a mob, killing five people in Boston, later called?

Describe the etl process to retrieve the data and load it : Describe the ETL process to retrieve the data and load it. Describe how the data would be integrated. Identify the metadata that would be useful to solve the problem.

Who was the governor of massachusetts : Who was the governor of Massachusetts in the early 1770s who was for an independent American colonies?

Purchasing cloth from british manufacturers : Who protested by meeting to spin yarn for cloth and avoid purchasing cloth from British manufacturers?

What role should external factors of demand play : What role should external factors of demand play in successful business models?- What is "Business Model Design and Innovation"?

House of burgesses to condemn the stamp act : In History, Who urged the House of Burgesses to condemn the Stamp Act?

User Account

All Pages