loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Combo: Informatica ETL & IDQ 9.x Online Training

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Raj

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Combo: Informatica ETL & IDQ 9.x Online Training

Combo: Informatica ETL & IDQ 9.x Online Training

Online Instructor led Course

Platform: GoToMeeting

20,000

1 Reviews
0 Interested

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

Recommendations & reviews from previous Customers:

Sanjith

"Raj was very helpful in nature and a very commendable knowledge in both ETL & IDQ technologies. Must appreciate his patience towards his students. "

attended Combo: Informatica ETL & IDQ 9.x Online Training


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Sanjith

"Raj was very helpful in nature and a very commendable knowledge in both ETL & IDQ technologies. Must appreciate his patience towards his students. "

attended Combo: Informatica ETL & IDQ 9.x Online Training


Date and Time

Not decided yet.

About the Trainer

Raj picture

Raj

Informatica & Oracle Certified Professional


Expert in ETL, Data Integration, Data Quality & Metadata Management
Seats Left-

Students Interested 0

Course Id: 28619