Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is ETL/ How does Oracle support the ETL process?

April 26, 2017ETL Oracle process support

0

0 Posted

What is ETL/ How does Oracle support the ETL process?

1 Answer

0

0 Posted

ETL is the Data Warehouse acquisition processes of Extracting, Transforming (or Transporting) and Loading (ETL) data from source systems into the data warehouse. Oracle supports the ETL process with their “Oracle Warehouse Builder” product. Many new features in the Oracle9i database will also make ETL processing easier. For example: * New MERGE command (also called UPSERT, Insert and update information in one step); * External Tables allows users to run SELECT statements on external data files (with pipelining support).