Learn Ab Initio Course
Top Rated Best Institute for Ab initio Training in Chennai provided by Real time working Experts. Learn basic through advanced ETL concepts, DW/BI Lifecycle In Depth, ETL Architecture using Ab initio with real-world ETL process implementations organized in Ab initio training institute in Chennai.
Ab initio Training center in Chennai (Regd: GREENS TECHNOLOGY) strongly determined to provide Realtime and Practical Trainings on Ab initio and Business Intelligence Tools by real time experienced professionals having more than 12 years of DW/BI experience in Ab Initio, Netezza, Unix, SQL, Perl, Shell Scripting, ETL Data Warehousing, Oracle, Business Intelligence, Enterprise Architecture PL/SQL, Databases, SDLC, Data Warehouse Architecture, Integration.About Our Trainer
As a Trainer, Mr.Ram work as a BI Consultant for a Leading MNC in Chennai with 12+ years experience in both software development and training and very keen in delivering the BEST Cognos Business Intelligence Trainings. The trainee can simply depend on Ram for his excellent Real Time examples on every part of the concept paired with in-depth discussions and Datawarehouse recommendations. All sessions are completely practical and very much interactive.
Specialties
ETL & Data Warehouse Consulting using Cognos and other ETL tools. 8+ years Cognos experience Including Version 10
Please Note: Trainer is a Realtime Expert and Currently working for one MNC. Hence all the Training Schedules (timings) are fixed. No One - One Trainings can be provided as of now.
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
Introduction to Ab Initio
- why it is a market leader in ETl,
- key features in Ab initio
- where it is being used and how helps complex business
Introduction to Ab Initio
- CO>OP
- GDE
- EME
- CONTINUOUS process
- BRE
Understanding the High Level Architecture of Ab Initio
- Deployment Process
- Master Process Creation
- Agent Process Creation
- Component Process Creation
- Successful Component Termination
- Agent Termination
- Host Termination
- Establishing a connection from GDE to EME and EME to Co>OP and EME and GDE
Data Manipulation Language (DML)
- Record Formats
- DML Expressions
- Transform Functions
Data Manipulation Language (DML)
- Input File
- Output File
- Intermediate File
- Lookup file
Data Manipulation Language (DML)
- Transform File(.xfr)
- Functions, Variables, Statements & Rules
Transform Components
- Filter by Expression
- Dedup Sorted
- Reformat
- Aggregate
- Scan
- Rollup
- Join
- Match Sorted
- Normalize
- Denormalize Sorted
Partition
- Partition by Key
- Partition by Expression
- Partition by Percentage
- Partition by Range
- Partition by Round-Robin
- Partition with Load Balancing
- Multifiles and Multidirectories De-partition Components
- Concatenate
- Gather
- Interleave
- Merge
Working with Database
- Input Table
- Output Table
- Run SQL
- Truncate Table
- Update Table
- Join with DB
Miscellaneous Components
- Redefine Format
- Gather Logs
- Replicate
- Run Program
- Thrash
File Transfer Protocol (FTP) Components
- FTP From
- FTP To
Validate Components
- Check Order
- Compare Records
- Validate Records
- Generate Records
- Generate Random Bytes
- Compute Checksum
- Compare Checksum
Sort
- Sort
- Sort within Groups
- Partition by Key & Sort
The Ab Initio Enterprise Meta> Environment(EME)
- High level anatomy of the EME
- Relation to sandbox environment
- Checking in your sandbox
- Checking out a graph or a sandbox
- Locking in order to change an object
- Tagging
- Common projects
- Phasing and check pointing
- Real time scenarios
