Category Archives: Data Warehouse ETL
Use Case: Automatic ETL schema generation
Semistructured source data with automatic ETL schema generation at SQL destination Problem: A Software as a Service (SaaS) company stores OLTP data in a mixed format of relational and semi-structured data. This multi-tenant data consists of workflow, form data and documents. … Continue reading
Posted in Data Warehouse ETL, Hadoop ETL, Json ETL
Tagged Automatic Schema Generation, Data Integration, ETL Software, Json ETL
Leave a comment
Data Lake vs Integrated Data Warehouse ETL
Data Warehouse ETL vs Data Lake ETL Intelligent Integration makes a fundamental change of the cost calculus between a Data Lake vs the IDW. A Data Lake is loosely integrated data typically placed in Hadoop. An IDW has tightly integrated … Continue reading
Posted in Data Warehouse ETL, Hadoop ETL, Json ETL, Teradata ETL
Tagged Data Lake ETL, Data Warehouse ETL, Json ETL
Leave a comment
