AB Initio

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

AB Initio is a data integration tool used for ETL (Extract, Transform, Load) processes. The AB Initio course aims to provide participants with a comprehensive understanding of the tool’s features, architecture, and functionality. Participants will learn how to use AB Initio to extract data from various sources, transform the data, and load it into target systems. They will also learn how to design and implement complex ETL processes using the tool’s graphical interface and command-line interface.

At the end of the training, participants will be able to:

 At the end of the course, participants will have the skills and knowledge required to build efficient and scalable data integration solutions using AB Initio.

Pre-requisite

All attendees should have a basic knowledge of data processing.

Duarion

4 days

Course Outline

  1. Braod Cast
  2. Partition by Expression
  3. partition by range
  4. partition by community
  5. partition by percentage
  6. partition by Round Robin
  1. Concatenate
  2. Gather
  3. Interleave
  4. Merge
  1. Sort
  2. Sort with in groups
  3. Sample
  4. Partition by key and sort
  1. Filter by expression
  2. Aggregate
  3. Scan
  4. Rollup
  5. Denormalize Sorted
  6. Normalize
  7. Reformat
  8. Match sorted
  9. Dedup sorted
  1. Run SQL
  2. Input Table
  3. Output Table
  4. Truncate Table
  5. Update table
  1. Gather logs
  2. Run program
  3. Redefine format
  4. Trash
  5. Replicate
  1. Input File
  2. Output File
  3. Lookup File
  4. Intermediate File
  1. FTP From
  2. FTP To
  1. Compress
  2. Uncompress
  3. Gzip
  4. Gunzip
  1. Check Order
  2. Generate Records
  3. Generate Random bytes
  4. Compare Records
  5. Compute Check Sum
  6. Compare Check Sum
  1. Record XML
  2. Write XML

Reviews