ETL
Abstract: IRI and DataSwitch have partnered to create an end-to-end, multi-featured metadata and AI-driven data engineering environment for: legacy data and ETL modernization, cloud data integration and migration, data governance and masking operations, and data democratization for business-friendly analytics. Read More
ETL
Abstract: The IRI Voracity data management platform provides data integration tools, including data pipeline automation for high-performance ETL (Extract-Transform-Load) operations. This article is the first in another series on how to create and use high-performance ETL workflows in the IRI Workbench GUI for Voracity. Read More
Data Transformation
Big data integration activities can happen outside the database in an extract, transform, load (ETL) environment, or inside the database in ELT:
http://www.iri.com/blog/data-transformation2/etl-vs-elt-we-posit-you-judge/
One example of an ELT operation would be Informatica’s Pushdown Optimization option, in which users transform data in a relational database like Oracle, or in Teradata. Read More
Data Transformation
Changing between column and row formats is an online analytical processing (OLAP) activity that optimizes data structures for queries and reports.
A pivot transformation turns multiple rows of data into one, denormalizing a data set into a more compact version by rotating the input data on a column value. Read More
