Thanks to all our readers for a very positive response to my previous blog on “Informatica PowerCenter Developers Guide to Talend”. The first part of the series provided an overview of the architectural differences between PowerCenter and Talend. It also provided a primer on Talend Studio …
Read Article
In this example, I have been asked to check if the corporate standard for naming employee documents has been adhered to. If not, I then want to know how many deviations are in the dataset. You have in your database a table of employees, employee documents (contracts …
Read Article
Authored by Darius Kemeklis, Myers-Holum, Inc It’s hard to believe that Data Warehousing (DW) has been around since 1970 when Bill Inmon first defined the term. The 1990’s saw Bill Inmon and Ralph Kimball dueling on two different Data Warehousing approaches, with Kimball publishing The Data Warehousing Toolkit. The 2000’s saw MPP …
Read Article
What is a Data Model? As Talend developers, we see them every day, and we think we know what they are: A structural definition of a business system data A graphical representation of business data A data foundation upon which to build business solutions These may …
Read Article
I recently started working with Talend as a Customer Success Architect. In this role, I help customers with architecture guidelines and best practices for managing their data strategies with Talend. Before joining Talend, I worked on several data warehouse implementations where Informatica PowerCenter was the common ETL …
Read Article
As HL7 is the de-facto standard in the health industry, we often get a lot of questions from customers about how to integrate different HL7 standard based systems using Talend and communicate via MLLP (Minimal Lower Layer protocol). In this blog, I will briefly introduce HL7 …
Read Article
Business Applications, Data Integration, Master Data Management, Data Warehousing, Big Data, Data Lakes, and Machine Learning; these all have (or should have) a common and essential ingredient: A Data Model; let us NOT forget about that; or, as in many situations I run into, ignore it completely! The …
Read Article
Case study underscores the long-term advantages of open-source ETL tools. I attend a lot of conferences pertaining to data integration, so I’ve seen a certain scenario unfold several times. The keynote speaker asks the audience for a show of hands: “How many of you are using …
Read Article
Recently I developed a proof of concept ETL job to strip product information from a website, translate it, and create a data set comprising the original text and the translated text. For my example, I chose to strip drug product names out of a French health authority website, and …
Read Article
Our journey in Talend Job Design Patterns & Best Practices is reaching an exciting juncture. My humble endeavor at providing useful content has taken on a life of its own. The continued success of the previous blogs in this series (please read Part 1, Part 2, …
Read Article