AB initio Training in Chennai

What is ETL testing?

ETL Concepts are clearly described in this course, ETL is short for extract, transform, load, three database function that are combined into one tools to pull data out of the one database and places it into the another database. Extracts is the process of read data from the database.Transform is the processing of convert the extract data from its previous form into the forms it need to be an so that is can be place into another databases.


Our Training Video Reviews
Think IT Training Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.

AB initio training in chennai provide real-world and placement focus AB initio training classes. Our Think IT training course include basic AB initio tutorial to advanced level.We design to get the placements in good MNC company in chennai as quick as once you complete the AB initio certification in chennai.Our AB initio trainer are AB initio certified expert and 5 year experience working professional with hand on real time multiples Ab initio project knowledge. We have design our AB initio course content & syllabus based on the student requirements to achieve everyone’s career goals.


AB Initio Training Duration

Regular Batch – Daytime, Morning and Evening
  • Time Duration : 45 hours


Weekend Batches – Saturday and Sunday & Holidays
  • Time Duration : 9 weeks


Fast Track course Training – (daily 5+ hours)
  • Time Duration : 2 weeks


Introduction to Data Warehousing
  • Data warehousing
  • Types of FACTS tables
  • Types of DIMENSION tables
  • Definitions
  • Types of Schemas in D/W
  • What is Data Mart
  • ETL Process
  • Types of Tables in D/W
  • Warehouse Approaches


AB INITIO Introduction
  • Ab Initio basics
  • Architecture
  • Graph Programming


Partition Components
  • Broadcast
  • percentage partition
  • Round Robin partition
  • Expression Partition
  • range partition
  • community partition


Departition Components
  • Concatenate
  • Interleave
  • Types of parallelism
  • Merge
  • Gather
  • Multi file System
  • Layouts


MFS (Multi File Systems) Components
  • Sort
  • Sample
  • Partition by key and sort
  • Sort with in groups


Transformation Components
  • Filter by expression
  • Scan
  • Normalize
  • Reformat
  • Rollup
  • Aggregate
  • Demoralized Sorted
  • Match sorted


Database Components
  • Run SQL
  • Update table
  • Output Table
  • Truncate Table
  • Input Table
  • Phase and checkPoints


Phase And Checkpoint Components
  • Gather logs
  • Redefine format
  • Trash
  • Run program
  • Replicate


Dataset Components
  • Input File
  • Lookup File
  • Intermediate File
  • Output File


#MODULE – 10
FTP Components
  • FTP From
  • FTP To


#MODULE – 11
Compress Components
  • Compress
  • Gzip
  • Gunzip
  • Uncompress


#MODULE – 12
Translate Components
  • Record XML
  • Project and Sandbox
  • Write XML


Enquiry for your free demo session and get special discounts for your preferred courses – Click Here


Hot Courses in Think IT

we'll one over 10 Years of experience you always the best guidance

Think IT Training