LEMURIA TECHNOLOGIES LIMITED INVITES YOU TO AN ABINITIO COURSE. PLEASE SHARE THIS TO YOUR COLLEAGUE AND FRIENDS WHO MAY INTERESTED Ab initio Developer Course Description Course Duration • Seven Days of instructor-led training • 60% lecture, 40% hands on lab Target Audience • Database developers with little or experience of Unix and DW Concept . Prerequisites • Windows GUI • knowledge of SQL • DW Concepts Course Overview This seven-day, instructor led course introduces students to Ab initio lecture and hands-on exercises. The course is designed for Database Developers who are new to Ab initio Data Intergration Product . Ab initio is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes. The course will introduce attendees to working with the Ab initio Co> Operating System and Graphical Development Environment (GDE) and Enterprise Meta>Environment (EME) Objectives After successfully completing this course, students should be able to: • Use Ab initio Support to resolve questions and problems with co> Operating system and GDE. • Use Ab initio Graph to build mappings that extract data from asource to a target, transforming it as necessary. • Use Ab initio Graph Components to cleanse, format, join, aggregate and route data to the appropriate targets • Perform error handling/trapping using Ab initio • Perform basic troubleshooting using Ab initio Component log and Phases . Course Agenda 1. Introduction to Ab initio • Operating Systems & Hardware Platforms that it supports 2. Products of Ab Initio Software Corporation • The Ab Initio Co>Operating System • Graphical Development Environment (GDE) • The Ab Initio Enterprise Meta>Environment (EME) 3. Understanding the High Level Architecture of Ab Initio 4. About the Co>Operating System • The Co>Operating System and the GDE • What is a graph?, What is a plan? • When you run a graph 5. How do we Connect from GDE to the Server (Run ? Settings) Host Profile File (.aih) , Connection, Co-Operating System, Shell & Host Directory 6. What is Graph Programming? What are the basic parts of an Ab Initio Graph? 7. Data Manipulation Language (DML) What is DML? , Basic syntax , Data types , Compound types ,Keys , Expressions , Global variables and named constants ,Trouble Shooting , Packages , Converting data values , Working with character sets in DML , External packages , Predefined named types 8. How do we build a basic Ab Initio Graph? Using .dat(Data File) & .dml(Record Format File) 9. Broad Classification of Components Dataset Components , Program / Computing Components 10. Editors in the GDE Record Format Editor , Expression Editor ,Transform Editor , Key Specifier Editor ,Package Editor ,Variables Editor ,Sequence Specifier Editor 11. Transform Functions Transform File(.xfr) , Functions, Variables, Statements & Rules 12. Transform Components - Multistage and Advanced Components FILTER BY EXPRESSION , MULTI REFORMAT ,REFORMAT , SORT , DEDUP SORTED ,NORMALIZE , ROLLUP , SCAN ,COMBINE , JOIN 13.Lookup Dataset’s & DML Lookup Functions DML utilities 14. Multifiles and Multidirectories 15. Steps to Building Applications What parameters are , Parameter sets , Parameter interpretation ,Parameter types , Input and local parameters , Input pset files ,Parameter overrides , Configuration psets 16.Component logs and errors Overview of logs, errors, and rejects ,Designing for errors ,Collecting log and error records with handler components ,Using logging in components ,Handling errors in components,Functions for handling errors, logs, and rejects ,Error escalation ,Error and log example graphs 17. What is Parallelism - Types Component ||’sm , Pipeline ||’sm , Data ||’sm, Repartitioning – When & Why 18. Partition and Departition Components Broadcast, Concatenate ,Gather , Interleave , Merge, Partition by Key ,Partition by Expression ,Partition by Percentage , Partition by Range , Partition by Round-Robin and Partition with Load Balancing 19. Layout Implications Sort within Groups , Find Spliters ,Sample , Partition by Key & Sort,Check point Sort 20.Working with Database’s. Introduction Database Configuration File (.dbc) 21. Interactive Database Components (IDB) INPUT TABLE , JOIN WITH DB ,MULTI UPDATE TABLE , OUTPUT TABLE ,RUN SQL , TRUNCATE TABLE,UPDATE TABLE 22 Miscellaneous Components GATHER LOGS , HANDLE ERRORS ,HANDLE LOGS , RUN PROGRAM ,THROTTLE , TRASH 23. Compress DEFLATE , INFLATE ,COMPRESS , UNCOMPRESS 24. Testing and Validation of Ab Initio Graphs using Validate Components Check Order ,Compare Records,Validate Records , Generate Records,Generate Random Bytes , create Data,Compute Checksum , Compare Checksum and Repair Input 25. Phasing & Checkpointing Reusability Features ,Sub graphs , Graph Parameters 26. The Ab Initio Enterprise Meta>Environment(EME) • High level anatomy of the EME • Relation to sandbox environment • Checking in your sandbox ,Checking out a graph or a sandbox • Locking in order to change an object ,Tagging • Common projects • Dependency and Impact analysis 27. Module XXV: Performance Tuning Ab Initio Graphs What is Good Performance?, Going Parallel , Serial Inputs ,,Phases , Record Formats and Components , Memory Usage and Various Tips 28. Object Discrepancy 29. Reusable graphs Onsite Training On-site training courses are designed to meet your specific business needs and requirements. Convenient and cost-effective, on-site training events are delivered at your location to reduce impact on your day-today business. Onsite training is ideal for companies who desire the flexibility of training at their location. You set the date and time, and we come to you! We provide a blending approach to learning - instructor-led training with hands on exercises and coaching - that encourages team building and collaboration, all in the convenience of your office. Extremely cost effective for multiple students • Your team is trained together • Your team is accessible • You pick the date Dedicated Virtual Training Dedicated virtual training courses offer the same time convenience as an onsite training class without the expense of instructor travel. Your team is trained privately, at your schedule, from any location that is accessible via the internet. Public Training & On Demand Courses are conveniently scheduled For Further information contact us @ 044 4204 9608 / 7913 or mail us to sathish@lemuriatech or corp@lemuriatech Thanks & Regards, Lemuria Technologies Limited No.1,1st Floor, Lake Area 1st Main Road, Nungambakkam, Chennai - 600 034
Posted on: Fri, 31 Jan 2014 11:45:08 +0000
Trending Topics
Recently Viewed Topics
© 2015