AB INITO TRAINING
JOB ORIENTED AB INITO TRAINING INSTITUTE IN CHENNAI
Job oriented AB INITIO training is offered by Software Testing Chennai in ADYAR, Chennai. Our course content is prepared to get placement in good IT field as soon as they complete the course. We have experienced faculty with deep knowledge on AB INITIO. We take responsibility for class room training with latest versions and also provide best lab handouts for practice including real time. We give practice exercise to our student to equip their knowledge in practical way.
WHAT IS AB INITIO?
AB INITIO uses ETL Extract, Transform and Load is a tool used for data analysis, data manipulation processing. It is BI uses six processing data.
WHY US?
Software Testing Chennai gives excellent training on ab inito training in chennai. We not only teach you the technologies but also share our real time implementation to gain practical knowledge on subject. Our trainers understand how business and technologies are connected with people. We provide AB INITIO course completion certificate after completing the course.
COURSE HIGHLIGHTS
- Free trial on courses for two days if a candidate likes the course these two days will adjust to actual classes
- We have experienced experts with 10 years of experience
- Real time project implementation
- Good placement
- Lab with good infrastructure
- Certification support
DETAILED SYLLABUS
DATA WAREHOUSING BASCIS AND AB INITIO
Introduction to Data warehousing
- What is Data warehousing
- Architecture of Data warehousing
- Definitions
- ETL Process
- Types of Tables in D/W
- Types of FACTS tables
- Types of DIMENSION tables
- Types of Schemas in D/W
- What is Data Mart
- Warehouse Approaches
Data Modelling
- Introduction to Data Modelling
- Entity Relationship model (E-R model)
- Data Modeling for Data Warehouse
- Dimensions and fact tables
- Star Schema and Snowflake Schemas
- Coverage Tables
- Fact less Tables
- What to look for in modelling tools
- Modelling tools
ETL Design process
- Introduction to Extraction, Transformation & Loading
- Types of ETL Tools
- What to look for in ETL Tools
- Key tools in the market
- ETL Trends & New Solution Options
Ab Initio
Introduction to Abinitio
Abinitio Architecture Graph Programming
Introduction to .dat and .dml files Partition Components
- Braod Cast
- Partition by Expression
- partition by range
- partition by community
- partition by percentage
- partition by Round Robin
Departition Components
- Concatenate
- Gather
- Interleave
- Merge
Multifile System(MFS) Types of parallelism Layouts Sort Components
- Sort
- Sort with in groups
- Sample
- Partition by key and sort
Transform Components
- Filter by expression
- Aggregate
- Scan
- Rollup
- Denormalize Sorted
- Normalize
- Reformat
- Match sorted
- Dedup sorted
Working with Databases Database components
- Run SQL
- Input Table
- Output Table
- Truncate Table
- Update table
Phase and check Points Miscellaneous component
- Gather logs
- Run program
- Redefine format
- Trash
- Replicate
Dataset Components
- Input File
- Output File
- Lookup File
- Intermediate File
FTP Components
- FTP From
- FTP To
Compress Components
- Compress
- Uncompress
- Gzip
- Gunzip
Validate Component
- Check Order
- Generate Records
- Generate Random bytes
- Compare Records
- Compute Check Sum
- Compare Check Sum
Translate components
- Record XML
- Write XML
- Project and Sandbox Performance Tuning