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
Business Intelligence (BI)
As IRI CoSort integrates and stages big data from a variety of sources, it plays a natural role in producing data for reporting and analytics.
CoSort not only transforms data for loading data warehouse tables, it can report at the same time, or feed data in filtered, aggregated, sorted, and properly formatted subsets (like .CSV Read More
Data Transformation
The IRI data management platform Voracity, as well as its constituent tools, can perform and speed big data warehouse extract, transform, load (ETL) operations, delaying the need for new hardware or expensive proprietary appliances: http://www.iri.com/blog/data-transformation2/a-big-data-quandary-hardware-or-software-appliances-or-cosort/ Read More
Big Data
Big Data Problem Big data volumes are growing exponentially. This phenomenon had been happening for years, but its pace began a more rapid acceleration in 2012. 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
Business Intelligence (BI)
Introduction: This blog discusses a brief overview of how IRI handles change data capture (CDC) solutions. Since the posting of this blog, IRI has created a wizard specifically for CDC solutions found in IRI Workbench. Read More
