Extract Transform Load (ETL) for bag store (Tumi.my)

  • Transactional databases cannot answer complex business questions that can be answered by ETL example.
  • A Data Warehouse provides a common data repository
  • ETL provides a method of moving the data from various sources into a data warehouse.
  • ETL process allows sample data comparison between the source and the target system.
  • ETL process can perform complex transformations and requires the extra area to store the data.
  • ETL helps to Migrate data into a Data Warehouse. Convert to the various formats and types to adhere to one consistent system.
  • ETL is a predefined process for accessing and manipulating source data into the target database.
  • ETL in data warehouse offers deep historical context for the business.
  • Extract is the process of reading data from a database. In this stage, the data is collected, often from multiple and different types of sources
ETL — Extract, Transform, Load

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Hindi Abstractive Text Summarization (Tutorial 10)

List in Python (Part-1)

Low-cost sensor data collection in the field — using your smartphone and a little python

D4S Sunday Briefing #99

Business Intelligence vs Process Mining: What’s the Difference?

an employee at the computer holds a lightbulb which contains mechanical cogs and is brightly lit up

The 7 Most Common Data Analysis Mistakes to Avoid

How to calculate Heikin Ashi candles in Python for trading

Mapping Immigration Flow Through Tree Rings

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
muhammad nazmi bin zainudin

muhammad nazmi bin zainudin

More from Medium

WM Questionnaire Part-7 Storage Unit Management

Installing SQL Server and Microsoft SQL Server Management Studio on Windows Server 2019 VM.

leetcode 460. LFU Cache

SubTally -A Subscription Management Application