+91 8142000093 info@tanviinfo.com

Ab Initio

TIS_Ab Initio

Ab Initio

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends
Category:

Course Content

Introduction to Abinitio software
Ab initio Architecute
• Understanding GDE
• Understanding Co-op System
• Understanding EME/Application hub
Understanding Host connection settings
• Configure host settings
Understanding Abinitio Jobs/ Graphs
• Basics of Graphs
• Building and executing graphs
• Understanding Sandboxes/Projects
Understanding components inside a graph
• Record formats, DML, Transform functions, Key specifiers
• Dataset components/ Table components/Program components
• Layout
• Parameters
• Validating the graphs and understanding the error messages
• Component Overview-Editors
• Record Format Editors
• Expression Editors
• Transform Editors
• Key Spefifier Editors
• Package Editiors
• Variable Editors

Component Overview-Dataset components
• Input file
• Output File
• Intermediate file
• Lookup files and Lookup Functions
Component Overview-Dataset components
• Filter by expression
• Dedup sorted
• Reformat
• Aggregate
• Scan
• Rollup
• Join
• Match sorted
• Normalize
• Denormalize Sorted
Understanding partitioning Concepts and mutifiles
• Understanding Multifiles
• Understanding Parallelism
• Data Parallelism
• Component Parallelism
• Pipeline parallelism
Component Overview-Partition components
• Broadcast
• Partition by key

• Partition by expression
• Partition by round robin
• Partition by range
• Partition by load balance
Component Overview-Departition components
• Gather
• Concatenate
• Interleave
• Merge
Component Overview-Database Components, dbc file configuration
• Understanding database configuration
• Input table
• Output table
• Run SQL
• Truncate Table
• Update Table
• Join with DB
Component Overview- Miscelleneous Components
• Redefine format
• Gather Logs
• Replicate
• Run Program
• Trash
Component Overview- Validate Components
• Check Order

• Compare Records
• Validate Records
• Generate Record
• Create Data
• Compute Checksum
Understanding Performance Tuning
• Component Folding
Additional Graph concepts
• Tagging
• Branching
• Checkin-Checkout
• Locking
• Common projects
• Dependancy analysys/Impact analysys
• Generic Graphs/Reusable Graphs
• Conditional components
• Concept of Phases and check point
Understanding Plans/ConductIT
Understanding Continuous Flows
Understanding various command line options/ configuration Variables
• m commands
• air commands
• configuration variables
• Environment variables