Pentaho Online Training Institute in Hyderabad India
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 nakshatraonlinetraining@gmail.com or Whatsapp to us on : 9290971883.
Pentaho Course Content
Course Duration : 30 Hrs
- Introduction
- Pentaho Data Integration Architecture
- Use Pentaho Data Integration
- Create a Connection to the DI Repository
- Interface Perspectives
- Use Perspectives Within Spoon
- Tour Spoon
- VFS File Dialogues in Spoon
- Model Perspective
- Visualization Perspective
- Instaview Perspective
- Customizing the Spoon Interface
- Terminology and Basic Concepts
- Transformations, Steps, and Hops
- Jobs
- More About Hops
- Create Transformations
- Get Started
- Save Your Transformation
- Run Your Transformation Locally
- Build a Job
- Executing Transformations
- Steps
- Databases
- Performance Monitoring and Logging
- Monitoring Step Performance
- Using Performance Graphs
- Logging Steps
- Implement Data Services with the Thin Kettle JDBC Driver
- Transactional Databases and Job Rollback
- Scheduling Transformations and Jobs From Spoon
- Input
- CSV File Input
- Data Grid
- Email Messages Input
- Fixed File Input
- Generate Rows
- Get Data From XML
- Get File Names
- Get Files Rows Count
- Get Table Names
- Load File Content In Memory
- Microsoft Access Input
- Microsoft Excel Input
- Table Input
- Text File Input
- Output
- Delete
- Insert/Update
- Microsoft Access Output
- Microsoft Excel Output
- Microsoft Excel Writer
- Table Output
- Text File Output
- Update
- XML Output
- Transform
- Add Sequence
- Add Value Fields Changing Sequence
- Add XML
- Calculator
- Number Range
- Replace in String
- Select Values
- Set Field Value
- Sort Rows
- Unique Rows
- Execute a Process
- If Field Value is Null
- Null if
- Process Files
- Append Streams
- Dummy (do nothing)
- Filter Rows
- Switch / Case
- Execute SQL Script
- Lookup
- Database Join
- Database Lookup
- Joins
- Join Rows (Cartesian Product)
- Merge Join
- Merge Rows (diff)
- Sorted Merge
- Group By
- Memory Group By
- Job
- Transformation
- Copy Files
- Copy or Remove Result Filenames
- Create a Folder
- Create File
- Delete File
- Delete Folders
- Move Files
- Wait For File
- Conditions Wait For
- Truncate Tables
JOBS
- Creating jobs
- Sequence jobs
- Conditional jobs
- Wait
- Success
- Failure
- Normal flow