Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in BI by (55.6k points)
recategorized by
Can anyone tell me what is ETL tool?

1 Answer

0 votes
by (119k points)

ETL tool allows any organization to extract, transform, and then load data in the target database or file.

You can use ETL tool for the following:

  • Extracts data from source systems
  • Transforms and cleans up the data
  • Indexes data
  • Summarizes data
  • Loads data into the warehouse
  • Tracks changes made to the source data needed for the data warehouse
  • Restructures keys
  • Maintains the metadata
  • Refreshes the warehouse with updated data

If you want to learn Informatica, check out this Informatica Course by Intellipaat

Also, watch this video on Informatica ETL tool:

Related questions

0 votes
1 answer
asked Nov 3, 2020 in BI by dev_sk2311 (45k points)
0 votes
1 answer
asked Jul 15, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Sep 9, 2020 in Azure by Amyra (12.9k points)
0 votes
1 answer
asked Jul 15, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Sep 19, 2022 in BI by vyeshma (31.9k points)

Browse Categories

...