Cargando…

Getting Started with Talend Open Studio for Data Integration.

7. Job Orchestration; What is a subjob; A simple subjob; On Subjob Error; On Component OK; Run If; Jobs as subjobs; Iterating and looping; Iterate connections; ForEach loop; Loop ""n"" times; Infinite loop; Duplicating and merging dataflows; Duplicating data; Merging data; Summar...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Finnigan, Kenneth
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Pub., 2012.
Temas:
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Table of Contents; Getting Started with Talend Open Studio for Data Integration; Getting Started with Talend Open Studio for Data Integration; Credits; Foreword; Foreword; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers, and more; Why Subscribe?; Free Access for Packt account holders; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Knowing Talend Open Studio; What Talend Open Studio is.
  • Use casesHistory of Talend Open Studio; Benefits of Talend Open Studio; Installing Talend Open Studio; Prerequisites; Installation guide; Other useful software; Text editor; MySQL; Sample jobs and data; Summary; 2. Working with Talend Open Studio; Studio definitions; Starting the Studio; Tour of the Studio; The Repository; The design workspace; The Palette; Configuration tabs; Outline and Code panels; Creating a new project; Creating an example job; Metadata; Summary; 3. Transforming Files; Transforming XML to CSV; Transforming CSV to XML; Maps and expressions.
  • Advanced XML output for complex XML structuresWorking with multi-schema XML files; Enriching data with lookups; Extracting data from Excel files; Extracting data from multiple sheets; Joining data from multiple sheets; Summary; 4. Working with Databases; Database metadata; Extracting data from a database; Extracts from multiple tables; Joining within the database component; Joining outside the database component; Writing data to a database; Database to database transfer; Modifying data in a database; Dynamic database lookup; Summary; 5. Filtering, Sorting, and Other Processing Techniques.
  • Filtering dataSimple filter; Filter and rejects; Filter and split; Sorting data; Aggregating data; Normalizing and denormalizing data; Data normalization; Data denormalization; Extracting delimited fields; Find and replace; Sampling rows; Summary; 6. Managing Files; Managing local files; Copying files; Copying and removing files; Renaming files; Deleting files; Timestamping a file; Listing files in a directory; Checking for files; Archiving and unarchiving files; FTP file operations; FTP Metadata; FTP Put; FTP Get; FTP File Exist; FTP File List and Rename; Deleting files on an FTP server.