"Combo: Informatica ETL & IDQ 9.x Online Training" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 28619

Course type: Online Instructor led Course

Platform: GoToMeeting

Raj picture
Raj
No Reviews Yet

Date and Time

Not decided yet.

Raj picture
Raj

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
* DEMO PROJECT
* 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
Parameters
-How to use parameters in Data Quality mappings, transformations and reference tables
Content
- 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.

Pre-requisites

* 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

Reviews

No reviews currently

Discussions

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more