AB Initio is an ETL tool used in data warehouse to calculate , manipulate data from different sources.
ABInitio is mainly used to apply transformation rules on data as per business requirements and feed all business units in required format.
Training by highly experienced Industry Experts
AB Initio is an ETL tool used in data warehouse to calculate , manipulate data from different sources.AB Initio is mainly used to apply transformation rules on data as per business requirements and feed all business units in required format.
Duration of Training : 6 weekends
There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.
1. Introduction to Abinitio, comparison of Abinitio with other ETL Tools.
2. Introduction to a Datawarehouse
3. Datawarehouse Architecture
1.Types of DatawareHouse Approaches
2.Facts & Dimensions
1.Modelling concepts Introduction
2.Types of schemas
3.Relationship Between GDE, Co>op, EME
4.Introduction to Sandbox
1.Creating a Sandbox
2. Relationship between Sandbox and EME
3. Air commands
4. check-in, check-out & locking
1.Introduction to Graph Programming
2. Components Introduction
3.Types of Various Components
4. Partition components
2.Departition Components like: Gather, concatenate, Merge & Interleave
2. Translate components
1.Read XML 2.Write XML
2. Read EXCEL & Write Excel
1. FTP Components
2. Compress Components
3. Sort Components
1. Transform Components:
a. Dedup- Sort
b. Filter By Expression components and its internal parameters functions
2. Reformat component and its Parameters
2.Executing all the string functions by using various transform components
a.Aggregate components and its parameters
b.Rollup Components and its parameters
c.Various Aggregation functions in rollup components
d. Scan component and its parameters
1.Join components and its parameters
2. Fuse Component and its internal parameters
1.De-Normalize Sorted Component
2.Match Sorted Components
1.Introduction to Database Components
2.Creating .dbc file
3. Different types of Orainterfaces in Database components
1 .New Components introduced in the latest version of Abinitio V3.0.5
1 .Interview related questions discussion
Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.