Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Combo: Informatica ETL & IDQ 9.x Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 28619

Course type: Online Instructor led Course

Platform: GoToMeeting

Raj picture
No Reviews Yet

Date and Time

Not decided yet.

Raj picture

Informatica & Oracle Certified Professional

About Raj

Expert in ETL, Data Integration, Data Quality & Metadata Management
No reviews currently

About the Course

This is a combination of both Informatica ETL & IDQ courses that covers from the fundamentals to advanced/real-time level.

Duration:: 40 Hours

*** Exclusive Benefits Offered***
* Fully licensed software (Installation & Configuration)
* Concepts of Unix Required for Informatica
* Deployment of DQ mappings into PowerCenter and their business use cases
* Numerous Exercises & Realtime Scenarios
* Topic wise course materials
* Assistance in Resume Building
* Job Oriented Training

Session Timings:
* Weekday Batches: (Mon - Sat)
Any one hour in the below mentioned timings as per the slot availability
Morning Hours: 05:00 AM - 10:00 AM IST
Evening Hours: 10:30 PM - 11:30 PM IST

* Weekend Batches: (Sat & Sun)
Two sessions (each 2 hours) per day both on Sat & Sun

Topics Covered

*********** ETL ***********

Overview of Data Warehousing
* Introduction to Data warehouse (What/Why/How) * Star schema/Snowflake schema/Galaxy schema
* Dimensions/Facts tables.
* Slowly Changing Dimensions and its types.
Basic ETL
* Introduction to Informatica PowerCenter
* (E)xtraction, (T)ransformation and (L)oading Process
* PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor) * Source and Target Object Definitions
* Transformation Concepts (Types, Classifications, Basic uses)
* ODBC & Relational Connections
* Working with Flatfiles
* Working with XML Files
* All PowerCenter Transformations
Advanced ETL
* Different Load Types
* Slowly Changing Dimensions (Type - 1/2/3)
* Indirect Method for Loading
* Mapplets and Reusable Transformations
* Parameters and Variables (Mapping and Workflow)
* Different Types of Tasks:
* Working with Links
* Worklets
* Scheduler
* Parallel and Serial Batching.
* User Defined Functions
* Incremental Aggregation
* Constraint Based Loading
* Target Load Plan
* Performance Tuning
* Pushdown Optimization
* Wizards
* Partitioning
* Debugger

************ IDQ *********
An Overview of Informatica Developer 9
Overview of Data Quality and Informatica Developer covering areas such as the GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects and Tips for working with Developer.
Analyst Collaboration
- Review Information from the Analyst
- Profiles/Comments/Tags
- Create/Add to Reference Tables
- Shared projects and team collaboration means no loss of information or duplication of work across projects
Developer Profiling
- Perform Join Analysis Profiling
- Perform Column Profiling
- Multi Object Profiling
- Build and execute a Mapping using core transformations - Configure Transformation Properties
Data Standardization
- Develop data standardization mapplets and mappings - Cleanse, transform and parse data
- Data Quality cleansing and parsing transformations
Address Validation
- Configuring a Reusable AV Transformation - AV Transformation Properties
- AV Inputs and Outputs
- Define a Reusable AV Mapplet
- Build and address validation mapping to incorporate your mapplet Matching - Grouping Data
- Key Generator Transformation
- Key Gen Methods and Properties
- Analyze Detail Report - DQ Matching
- Perform matching using the Match Transformation - Match Properties
- Matching Algorithms
- Cluster Analysis Report
- Create and update matching Mapplets - Additional Matching Transformations
Identity Matching
- Build matching mappings using Identity Matching - Identity Populations and Strategies
Automatic Consolidation
- Automatically associate and consolidate your match data using a variety of association and consolidation - Transformations and techniques
Manual Consolidation Using the Data Quality Assistant
- Build mappings to create and populate the DQA tables using the new Exception Transformation - Perform Manual consolidation and bad record management using the DQA
PowerCenter Integration
- Execute Data Quality mappings/mapplets in PowerCenter
Object Import/Export
- Learn how to export and import projects using both basic and advanced methods
DQ for Excel
- Run Data Quality mappings on Excel spreadsheets
-How to use parameters in Data Quality mappings, transformations and reference tables
- Content availability with IDQ9
- Content Management Service
- How to configure AV information - Accelerators
- Core Accelerator

Who should attend

Any technology aspirant, be it freshers or experienced.


* SQL Basics
* Good internet connectivity (min 512kbps)

What you need to bring

Regular practice of topics covered is what expected at the least for every next class

Key Takeaways

* Understanding the concepts of Data Warehousing, Data Integration & Data Quality
* Ability to design and develop complex mappings
* Configuring Workflows as in real time environment
* Troubleshooting errors/failures
* Gain hands-on experience with multiple exercises and various real time scenarios and a Demo Project
* Confidence to excel your career as an efficient Informatica Developer/Consultant


No reviews currently


Post your requirement and let us connect you with best possible matches for Informatica ETL coaching Post your requirement now