Abinitio

Abinitio

ABINITIO ONLINE TRAINING COURSE CONTENT
• Datawarehousing concepts
• AbInitio Introduction
• Tool description and Background
• Detailed Architecture
• Products suite
• GDE, Co>Op, EME
• Graph and its features
• Components, Flows, Ports, Layouts
• DAT, DML, XFR, DBC files
• Parallelism and its types
• Phases, checkpoints and Recovery

• Component Organizer
• Description and Usage
• Dataset components
• Input file
• Output file
• Intermediate file
• Lookup file
• Adhoc Multi file
• Read/Write Multiple files
• Database components
• Input table
• Output table
• Truncate table
• Update table
• Run SQL
• Join with DB
• Multi update table
• Sort components
• Sort
• Sort within groups
• Partition by key and sort
• Transform components
• Reformat
• Filter by expression
• Dedup sorted
• Rollup
• Scan
• Join
• Scan with Rollup
• Normalize
• Multi Reformat
• Miscellaneous components
• Replicate
• Leading records
• Trash
• Handle logs
• Handle errors
• Redefine format
• Run Program
• Compress components
• Deflate
• Inflate
• Compress
• Uncompress
• Validate components
• Check order
• Compare records
• Create data
• Generate records
• Validate records
• FTP components
• FTP from
• FTP multiple from
• FTP to
• FTP multiple to
• SFTP from
• SFTP to
• Mail components
• Send mail
• Send message
• Send multiple messages
• Partitioning components
• Partition by expression
• Partition by key
• Partition by percentage
• Partition by round robin
• Partition with Load balance
• Partition by Range
• Gather
• Interleave
• Merge
• Concatenate
• Broadcast
• Multifile system
• Introduction
• Creation of multifile system, multifile and multi directory
• Utility commands (M commands)
• Parameters
• Introduction
• Graph Parameters
• Project parameters
• Interpretation
• Subgraphs
• Conditional components
• Built-In functions
• Enterprise meta environment
• Introduction
• Project vs. Sandbox
• Checkin vs. Checkout
• Air commands
• Conduct>IT Introduction
• Plans and Psets
• Tasks and Methods
• Sub plans and looping
• Dynamic parameters
• Performance tuning
• Case studies