ETL
Abstract: IRI and DataSwitch have partnered to create an end-to-end, multi-featured metadata and data engineering environment to: modernize legacy data and ETL jobs, create and orchestrate data mapping operations with AI, mask PII on the fly, and wrangle data in business-friendly ways for analytics. Read More
ETL
This starts another series of articles on how to create and use flows in the IRI Workbench GUI for Voracity. It follows the first series of articles on creating flows from existing CoSort/SortCL job scripts. 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
