1.0IRIhttps://www.iri.com/blogJason Koivuhttps://www.iri.com/blog/author/jasonk/ETL, ELT & IRI in Betweenrich600338<blockquote class="wp-embedded-content" data-secret="3PeIGBeA1u"><a href="https://www.iri.com/blog/data-transformation2/etl-elt-iri-in-between/">ETL, ELT & IRI in Between</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.iri.com/blog/data-transformation2/etl-elt-iri-in-between/embed/#?secret=3PeIGBeA1u" width="600" height="338" title="“ETL, ELT & IRI in Between” — IRI" data-secret="3PeIGBeA1u" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
/* ]]> */
</script>
https://www.iri.com/blog/wp-content/uploads/2012/12/etl-diagram.jpg312200The 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/ For ETL, Voracity supports: FAst extraCT (FACT) for native, parallel VLDB extraction CoSort’s Sort Control Language (SortCL) and Hadoop MapReduce, Spark, Storm,Read More