Online ABINITIO Training Institute from India
Contact us:
Swathi,
+91-9989378222,
trainings@owbonlinetraining.com
ABINITIO Online Training Center from Hyderabad India
Course Content:
Introduction to Data Warehousing
Role of ETL
Introduction to Ab Initio
Ab Initio Tool Components
Architecture of Ab Initio
Connectivity between GDE and CO
What Ab Initio Programming?
Graph Components
Graph Components
DML – Data Manipulation Language
To Prepare the Data (.dat) file
Component Layouts
Graph Development, Execution and debugging
Dataset components
Input file
Output file
Lookup file
Intermediate fileInput table
Output table
Partition Concepts
Data parallelism
Pipeline parallelism
Component parallelism
Partition & De-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
MFS (Multi-File system)
MFS file system concepts
Difference between serial and MFS file system
Introduction to Sub-graphs
Parameters and Input parameters
Variables, Statements and Business Rules
Sort components
Sort
Sort within groups
Sample
Find splitter
Partition by key and sort
Transform Components
Aggregate
Filter by Expression
Roll-up
Scan
Scan with roll-up
Join
De-dup Sorted
Match- sorted
Reformate
Multi-reformate
Normalize and De-Normalize
Database Components
Input table
Output table
Truncate table
Update table
Join with DB
Multi update table
Run SQL
Compress Components
Compress
Deflate
Inflate
Uncompress
FTP Components
FTP to
FTP from
Miscellaneous Components
Gather Logs
Redefine format
Replicate
Run Program
Throttle
Trash
Generate
EME (Enterprise Meta Environment) Tool
Introduction and Overview