Author Topic: Why do we need ETL? What are the advantages and disadvantages of using this?  (Read 74 times)

0 Members and 1 Guest are viewing this topic.

Offline rpmolecule

  • Full Member
  • *
  • Posts: 231
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Why do we need ETL? What are the advantages and disadvantages of using this?

Techronnati | where technology never sleeps


Mountain View

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 359
  • Karma: +1/-0
    • View Profile
- i'ts primary purpose is for Data-warehouse population - ETL tool can be used to populate the dimensions & fact tables of a data-warehouse
- Data migration - ETL tool can be used to migrate or transfer the data between variety of sources like databases, CRMs, cloud, files, emails etc.
- Transferring huge data - ETL tools are used to benefit in the transfer rate as they benefit from different technologies like parallel processing, selective processing, etc.
- Data cleansing- ETL tool can be used to cleanse your data i.e. remove any inconsistent or ambiguous data   
- Source for reports & analysis - ETL readies the data for further representation in the data warehouse in the form of reports or analysis.
- Big data support - ETL tool supports many big data options such as Hadoop, etc.

 

Related Topics

  Subject / Started by Replies Last post
9 Replies
296 Views
Last post April 04, 2017, 04:23:48 AM
by LadyProgrammer
1 Replies
158 Views
Last post September 08, 2016, 08:25:40 AM
by nomadic
2 Replies
1040 Views
Last post November 27, 2015, 06:59:34 AM
by GBTalk
6 Replies
113 Views
Last post December 06, 2016, 11:18:07 AM
by h2obubbler
0 Replies
86 Views
Last post October 04, 2016, 06:32:27 AM
by rpmolecule

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.