Pentaho Online Training Course Content

Who Should Attend

• Developers with any RDBMS Applications

Module I: Introduction to Pentaho

• Salient Features of Pentaho

Module II: AbInitio Architecture

• The Pentaho Co-Operating System
• Graphical Development Environment (GDE)
• Intro to The Pentaho Enterprise Meta-Environment (EME)

Module III: Sandbox and Parameter details

• What is sandbox and its usage
• Public and private parameters

Module IV: Graph Programming

• What is graph programming and basic parts of AbInitio graph building
• What is the Anatomy of Running a Job
• How do we Connect from GDE to the Server (Run ? Settings)
• Broad classification of components
• Editors in the GDE
• XFR and its usage

Module V: Data Manipulation Language Overview (DML)

• Record Formats
• DML Expressions
• Transform Functions
• Key Specifiers

Module VI: Components · Dataset Components

• Input File
• Output File
• Intermediate File
• Lookup file
  

  Transform Components

  • Filter by Expression
  • Dedup Sorted
  • Reformat
  • Aggregate
  • Scan
  • Rollup
  • Join
  • Match Sorted

  Partition Components

  • Broadcast
  • Partition by Key
  • Partition by Expression
  • Partition by Percentage
  • Partition by Range
  • Partition by Round-Robin
  • Partition with Load Balancing

  De-partition Components

  • Concatenate
  • Gather
  • Interleave
  • Merge

  Database Components

  • Input Table
  • Output Table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join with DB

  Sort Components

  • Sort
  • Sort Within Groups

  Miscellaneous Components

  • Redefine Format
  • Gather Logs
  • Replicate
  • Run Program
  • Trash

Module VII: Parallelism

• Component Parallelism
• Pipeline Parallelism
• Data Parallelism
• Multifile

Module VIII: AbInitio functions

• AbInitio in-build functions
• Lookup fuctions

Module IX: AbInitio Best Practices and Performance Tuning

• Phasing and Checkpoints
• Sub-graphs
• Serial Input Vs Multifile
• Fan-In and Fan-Out

CASE STUDY COVERING ALL THE ABOVE TOPICS

We are providing Pentaho Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Pentaho online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our Pentaho online training from their home in their convenient timings. For more details on Pentaho Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

Pentaho online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India