Course Information
- Course Price $250
- Total Students 800+
- Course Duration 4 Weeks
Description
The Ab Initio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, Enterprise Meta>Environment, Data Profiler and Conduct>It. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis. Ab Initio Co>Operating System is a foundation for all Ab Initio applications and provides a general engine for integration of all kinds of data processing and communication between all the tools within the platform. It runs on OS/390, zOS on Mainframe, Unix, Linux, and Windows. It enables distributed and parallel execution, platform-independent data transport, establishing checkpoints and monitoring of the process. It implements data execution parallelism by using data parallelism, component parallelism and pipeline parallelism.
Syllabus
- Introduction to Abinitio
- Ab Initio Architecture
- Graph Programming
- Introduction to .dat and .dml files
- Broadcast
- Partition by Expression
- partition by range
- partition by community
- partition by percentage
- partition by Round Robin
- Concatenate
- Gather
- Interleave
- Merge
- Multifile System (MFS)
- Types of parallelism
- Layouts
- Sort
- Sort within groups
- Sample
- Partition by key and sort
- Functions
- Filter by expression
- Aggregate
- Scan
- Rollup
- Denormalize Sorted
- Normalize
- Reformat
- Match sorted
- Dedup sorted
- Working with Databases
- Run SQL
- Input Table
- Output Table
- Truncate Table
- Update table
- Phase and checkpoints
- Gather logs
- Run program
- Redefine format
- Trash
- Replicate
- Input File
- Output File
- Lookup File
- Intermediate File
- FTP From
- FTP To
- Compress
- Uncompress
- Gzip
- Gunzip
- Check Order
- Generate Records
- Generate Random bytes
- Compare Records
- Compute Checksum
- Compare Checksum
- Record XML
- Write XML
- Project and Sandbox
- Performance Tuning
