SSIS - What Is ETL (Extract, Transform, Load) ?

ETL Stands for Extract Transform and Load. Every day working at different organization/s we come across different scenarios where we have to extract data from different sources such as Excel, Text Files, XML, Database systems etc. and then clean that data or transform that data according to our required format and save it to Destinations such as Database system or in different file types.

To perform ETL task , there are different tools available in market. Some of them are listed below


  • SQL Server Integration Services
  • IBM Infosphere Information Server
  • PowerCenter Informatica
  • Talend Studio for Data Integration
  • Oracle Data Integrator (ODI)
  • Clover ETL
  • Centerprise
  • Pentaho Data Integration
SQL Server Integration Services is an ETL tool that can be used to extract data from different types of sources by using Sources (OLE DB Source, File File Source, Excel Source etc.) that are built in the tool.

To Transform data, SSIS Provide different type of transformations such as Aggregate, Lookup, Data Conversion,Derived Column etc. so the source data can be transformed in any required format. 

For Loading, It provides different types of Destinations such as OLE DB Destination, ODBC Destination, ADO Net Destination , Flat File, Raw File ,Excel File etc. where data can be loaded once transformed in required format. 

7 comments:


  1. Interesting blog, here a lot of valuable information is available, it is very useful information informatica online training

    ReplyDelete
  2. I like your post very much. It is very useful for my research. I hope you can share more info about this. Keep posting mule 4 certification
    servicenow developer Certification
    Workday training
    Workday financial training
    Workday HCM Online training

    ReplyDelete
  3. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    workday studio online training
    best workday studio online training
    top workday studio online training

    ReplyDelete
  4. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    mulesoft online training
    best mulesoft online training
    top mulesoft online training

    ReplyDelete

  5. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.I want to share about Mulesoft training in hyderabad .

    ReplyDelete