Steps on ETL Process

  • Posts: 22
  • Thank you received: 0

Steps on ETL Process was created by Dave

Hello! Quick question.

What are the steps during ETL process?
5 years 8 months ago #14285

Please Log in or Create an account to join the conversation.

  • Posts: 87
  • Karma: 9
  • Thank you received: 15

Replied by KevinJohn on topic Steps on ETL Process

Good Question

Basically, data are extracted from the source database, then it will be transformed for storing it the desired format, structure for the purposes of business role, querying and analysis and stored permanently on the desired data warehouse.

The following are the steps involved :
  • Defining the source ( identify the odbc connection to the database source )
  • Defining the target (creating the odbc connection to the target database )

  • Create the mapping ( Apply transformations and define the data flow from source to target )

  • Create the session ( Mapping instructions )

  • Create the work flow ( Instructions that run on the sessions )

Choosing right ETL Tool
  • Standard Edition is designed for desktop user who just wants to run data load or transformation manually.

  • Professional Edition is designed for user who wants to execute business automation processes manually (Developers).

  • Enterprise Edition is designed for user who wants complete automation of business processes.
The following user(s) said Thank You: Dave
5 years 8 months ago #14286

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies