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

 

#MODULE – 1
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

 

#MODULE – 2
AB INITIO Introduction
  • Ab Initio basics
  • Architecture
  • Graph Programming

 

#MODULE – 3
Partition Components
  • Broadcast
  • percentage partition
  • Round Robin partition
  • Expression Partition
  • range partition
  • community partition

 

#MODULE – 4
Departition Components
  • Concatenate
  • Interleave
  • Types of parallelism
  • Merge
  • Gather
  • Multi file System
  • Layouts

 

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

 

#MODULE – 6
Transformation Components
  • Filter by expression
  • Scan
  • Normalize
  • Reformat
  • Rollup
  • Aggregate
  • Demoralized Sorted
  • Match sorted

 

#MODULE – 7
Database Components
  • Run SQL
  • Update table
  • Output Table
  • Truncate Table
  • Input Table
  • Phase and checkPoints

 

#MODULE – 8
Phase And Checkpoint Components
  • Gather logs
  • Redefine format
  • Trash
  • Run program
  • Replicate

 

#MODULE – 9
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

GET STARTED
Think IT Training