Posts

Showing posts with the label job

New Article

Talend Certification Tips - Tip #002 : Know your tMap Joins

Image
Hi Talend Addicts, Ready to learn more about the Talend great ETL tool! This post is part of the new series discussing the most important things (Tips) to know for anybody who want to tackle the Talend Open Studio for Data Integration Certification Exam. Today's Tip is:  Tip #002: Know your tMap Joins! tMap is one, if not THE, most important component in a Talend Job.  P ersonally  I have never seen any Talend Job without at least one occurence of this component, and  believe  it or not many questions around this component on the certification exam! the tMap can be used to (obviously) map data from input to output, but even more. Map data - already said that, but very important, so I say it again! Filter input data Filter output data Transform data Join data In today's post I'll focus on the last but not least one - JOIN Data So let's kick this off with some examples; and see what are the different types of joins you can build with Talend tMap component. Settin...

Talend Certification Tips - Tip #002 : Know your tMap Joins

Image
Hi Talend Addicts, Ready to learn more about the Talend great ETL tool! This post is part of the new series discussing the most important things (Tips) to know for anybody who want to tackle the Talend Open Studio for Data Integration Certification Exam. Today's Tip is:  Tip #002: Know your tMap Joins! tMap is one, if not THE, most important component in a Talend Job.  P ersonally  I have never seen any Talend Job without at least one occurence of this component, and  believe  it or not many questions around this component on the certification exam! the tMap can be used to (obviously) map data from input to output, but even more. Map data - already said that, but very important, so I say it again! Filter input data Filter output data Transform data Join data In today's post I'll focus on the last but not least one - JOIN Data So let's kick this off with some examples; and see what are the different types of joins you can build with Talend tMap component. Settin...

Talend Certification Tips - Tip #001 : Group of Contexts, Contexts & Context Variables

Image
Hi Talend Addicts, It has been a while since my last blog about Talend :) But I'm back to share more knowledge about this great ETL tool! In fact I will start a new series discussing about the most important things (Tips) to know for anybody who want to tackle the Talend Open Studio for Data Integration Certification Exam using some concrete examples with screenshots and step by step guidelines. Let's kick this off with this first blog in a future long series of blogs.

Integrate job with Windows Explorer

Image
In this tutorial we are going to learn how to integrate a job with the Windows Explorer so we can run our job on a file using the context menu.

Export job that can be run from command line

Image
This tutorial is going to show us how to use the opens source ETL Talend Open Studio to create a job that gets 3 input parameters and then generate a result depending on those three inputs.

Création d'un job avec l'ETL Talend Open Studio qui lance une MACRO Excel

Image
Ce tutoriel va nous présenter comment réaliser un job, avec le fameux ETL Talend Open Studio, qui nous permettra de lancer une MACRO Excel.  

Création de routines avec l'ETL Talend Open Studio

Image
Ce tutoriel explique la création et l'utilisation des routines de l'ETL Open Source Talend Open Studio dans un job simple.

Création de job dynamique avec l'ETL Talend Open Studio

Image
Ce tutoriel va nous présenter comment réaliser un job dynamique, en fait on va créer un simple job qui lancera une requête de type "select" sur une table d'une base de données Oracle, la particularité de cette requête c'est qu'elle contiendra une partie dynamique saisie par l'utilisateur final.

Création du tout premier job Talend Open Studio

Image
Ce tutoriel explique l'utilisation de l'ETL Open Source Talend Open Studio pour la transformation d'une table d'une base de données Oracle en une multitude de fichiers XML, un fichier XML par ligne.