Talend Open Studio cookbook : over 100 recipes to help you master Talend Open Studio and become a more effective data integration developer /: over 100 recipes to help you master Talend Open Studio and become a more effective data integration developer. (©2013)

• Record Type: Book
• Further Information: Note: Rick Barton.
• Other Names: Barton, Richard Daniel
• Contents: Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction and General Principles; Before you begin; Installing the software; Enabling tHashInput and tHashOutput; Chapter 2: Metadata and Schemas; Introduction; Hand-cranking a built-in schema; Propagating schema changes; Creating a generic schema from the existing metadata; Cutting and pasting schema information; Dropping schemas to empty components; Creating schemas from lists; Chapter 3: Validating Data; Introduction; Enabling and disabling reject flows. Gathering all rejects prior to killing a jobValidating against the schema; Rejecting rows using tMap; Checking a column against a list of allowed values; Checking a column against a lookup; Creating validation rules for more complex requirements; Creating binary error codes to store multiple test results; Chapter 4: Mapping Data; Introduction; Simple mapping and tMap time savers; Creating tMap expressions; Using the ternary operator for conditional logic; Using intermediate variables in tMap; Filtering input rows; Splitting an input row into multiple outputs based on input conditions. Joining data using tMapHierarchical joins using tMap; Using reload at each row to process real-time / near real-time data; Chapter 5: Using Java in Talend; Introduction; Performing one-off pieces of logic using tJava; Setting the context and globalMap variables using tJava; Adding complex logic into a flow using tJavaRow; Creating pseudo components using tJavaFlex; Creating custom functions using code routines; Importing JAR files to allow use of external Java classes; Chapter 6: Managing Context Variables; Introduction; Creating a context group; Adding a context group to your job. Adding contexts to a context groupUsing tContextLoad to load contexts; Using implicit context loading to load contexts; Turning implicit context loading on and off in a job; Setting the context file location in the operating system; Chapter 7: Working with Databases; Introduction; Setting up a database connection; Importing the table schemas; Reading from database tables; Using context and globalMap variables in SQL queries; Printing your input query; Writing to a database table; Printing your output query; Managing database sessions; Passing a session to a child job. Selecting different fields and keys for insert, update, and deleteCapturing individual rejects and errors; Database and table management; Managing surrogate keys for parent and child tables; Rewritable lookups using an in-process database; Chapter 8: Managing Files; Introduction; Appending records to a file; Reading rows using a regular expression; Using temporary files; Storing intermediate data in the memory using tHashMap; Reading headers and trailers using tMap; Reading headers and trailers with no identifiers; Using the information in the header and trailer.
• Publisher Details: Birmingham, UK : Packt Publishing
• Publication Date: 2013
• Copyright Date: 2013
• Extent: 1 online resource (270 pages)
• Subjects: 005.74; COMPUTERS -- Databases -- Data Warehousing; Data integration (Computer science); Database management; COMPUTERS -- Database Management -- General; Data integration (Computer science); Database management; COMPUTERS -- Information Technology; Electronic books
• Languages: English
• ISBNs: 9781461949503; 1461949505; 9781782167273; 1782167277
• Related ISBNs: 9781782167266
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.