ab intio online trainng

Abinitio – Course Contents
Page 1 of 2
1. Abinitio Overview
a. Abinitio Software, General-purpose data processing platform
b. Abinitio Platforms,
2. Connecting to Co>Operating Systems - Basics
3. Graph Basics
a. Creating Graph, collection of dataset components
b. Programming component
c. DML. and XFR’s
4. Concept of a dataset.
5. Concept of a component
a. Component Basics
b. Component categories
c. Transformation and Processing
6. Applications of Ab Initio Software
7. Ab Initio Product Architecture
8. Abinitio GDE
a. Abinitio GDE
b. Component Window
c. Connecting to Co>Operating Systems
d. Editing the Host Profile
e. Host Profile Settings
9. Basic Components
a. Dataset Components
b. Types Of Components-
i. Departition Components
ii. Compress:
iii. FTP :
iv. Sort
v. Transform Components - Data Transformation
vi. Log, Error and Reject ports
vii. Transform Function
viii. Transform Editor
ix. Sorting
x. Other Components
1. Partition Components
2. Miscellaneous
3. Datasets Component
4. Lookup File
10. Advanced Components
a. Rollup
b. Join
c. Input Table
d. Output Table
e. Others
11. A Practical Introduction to Ab Initio Software
a. Basics of Constructing Applications
Abinitio – Course Contents
Page 2 of 2
b. Basics of Parallelism
c. Basics of Data Partitioning
d. Multifiles
12. Sample Graph
13. Flow of Execution
14. EME Overview
a. What is EME ?
b. EME Project Hierarchy
c. Steps for EME Datastore settings
d. Procedure for project Checkin-Checkout
e. EME Deployment
15. Parameter List
a. Defining variables in parameter list
16. Types of Scripts
a. Display Script :
b. Wrapup Script :


---------------------------------------------------or----------------------------------------------------

Introduction to Abinitio Course content

Introduction to Data Warehousing
Role of ETL
Introduction to Ab Initio
Graph Components
Dataset components
Partition Concepts
Partition components
De- Partition Components
MFS (Multi-File system)
Introduction to Sub-graphs
Sort components
Transform Components
Database Components
Compress Components
FTP Components
Miscellaneous Components
EME (Enterprise Meta> Environment) Tool Basics
Conclusion

Course Content in Elaborate

1.     Introduction to Abinitio
2.     Abinitio Architecture
3.     Project and Sandbox
4.     Graph Programming
5.     Introduction to Ab Initio DML
6.      Transform Components

• a.     Filter by expression
• b.     Aggregate
• c.     Scan
  d.     Rollup
• e.     Denormalize Sorted
• f.     Normalize
• g.     Reformat
• h.     Dedup sorted
  

7.     Types of parallelism
8.      Layouts
9.     Multifile System(MFS)
10.    Partition Components

• a.     Braod Cast
• b.     Partition by Expression
• c.     partition by range
• d.     partition by community
• e.     partition by percentage
• f.     partition by Round Robin
  

11.      Departition Components

• a.     Concatenate
• b.     Gather
• c.     Interleave
• d.     Merge
  

12.    Sort Components

• a.     Sort
• b.     Sort with in groups
• c.     Sample
• d.     Partition by key and sort
  

13.     Working with Databases
14.     Database components

• a.     Run SQL
• b.     Input Table
• c.     Output Table    
• d.     Truncate Table
• e.     Update table
  

15.     Phase and check Points
16.     Miscellaneous component

• a.     Gather logs
• b.     Run program
• c.     Redefine format
• d.     Trash
• e.     Replicate
  

17.     Dataset Components

• a.     Input File
• b.     Output File
• c.     Lookup File
• d.     Intermediate File
  

18.     FTP Components

• a.     FTP From
• b.     FTP To
  

19.     Compress Components

• a.     Compress
• b.     Uncompress
  c.     Gzip
  d.    Gunzip
  

20.     Validate Component

• a.     Check Order
• b.     Generate Records
• c.     Generate Random bytes
• d.     Compare Records
• e.     Compute Check Sum
• f.     Compare Check Sum
  

21.     Translate components

•    Record XML
•   Write XML
  

22.    Performance Tuning