What is the need for ETL?
Whenever the business needs data to be analyzed for patterns & insights, data needs to be brought from different sources to one point.ETL takes data that is heterogeneous and makes it homogeneous. With ETL it would be Possible to programmatically analyze heterogeneous data and derive business intelligence from it.
Credo Systemz is the leading training provider in Chennai for ETL Informatica. We are providing classroom training as well as Online Training by Technical experts who are having more than 9 years of experience in IT Industry. We will be covering all Schemas with practical scenarios.
Our Software Training Institute in Chennai is well recognized in the IT industry for its training standard in ETL that helps us trained more than 30,000 people across the globe. We are mainly focused much on the project-oriented ETL testing with industrial experts.
Course Features
- Duration60 hours
- Skill levelAll level
- Batch Strength15
- AssessmentsYes
- Mock InterviewsYes
- Resume BuildingYes
- PlacementsYes
- Flexible TimingYes
- Fee InstallmentsYes
- LanguageTamil/English
Section 1
- Introduction to Data Warehousing
- Necessity of Data warehousing
- Relationship between OLTP, OLAP and ETL
- OLAP VS OLTP
- Architecture of Data warehousing
- What is Data marts ?
- Modelling – Dimensional modeling
- Schema’s in Data warehousing
Section 2
- Star Schema
- Snowflake schema
- Fact tables and its usages
- Fact vs dimensional tables
- Normalization vs De-Normalization
Section 3
- What is ETL?
- ETL Architecture and explanations
- ETL project – SDLC and STLC
- Types of complexity – Duplicate data, loss of data, fault in Business process
- Workflow activities in the ETL
Section 4
- Different types of ETL testing
- SQL Queries used in the ETL testing
- How to perform the incremental load testing?
- ETL Tools in market – Informatica, datastage and Ab initio etc
- Components in power center
- What is repository manager and workflow manager?
- Explanation of workflow monitor
- Designer and its users
Section 5
- Working with targets and Sources
- Relational targets vs flat file targets
- Different transformations
- Sorter
- Joiner and its exercise
- Expression
- Router
- Aggregator
- Sequence generator
Section 6
- Working with Unions
- Store procedures
- Slowly changing dimensions
- Play around with session
- Tasks – Decision, Control and Timer task
Section 7
- How to Schedule Work Flow?
- How to transform data from XML source?
- Working with performance tuning
- Different types of partitioning
- Dynamic
- Pipeline
- Pushdown optimization
- Preparation and review of test cases
- Execution of test cases
- Preparation of test reports
You will be going through detailed 2 to 3 months of Informatica Hands-on training
- Detailed instructor led sessions to help you become a proficient Expert in Informatica.
- Build a Informatica professional portfolio by working on hands on assignments and projects.
- Personalised mentorship from professionals working in leading companies.
- Lifetime access to downloadable Informatica course materials, interview questions and project resources.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
