Informatica Data Quality - IDQ

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting/TeamViewer/Hangout/Skype

Course ID: 40365

Course type: Online Instructor led Course

Platform: GoToMeeting/TeamViewer/Hangout/Skype

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

K Gowtham picture
K Gowtham

B.Sc Computer Science

About K Gowtham

I am working as Solution/Technical Architect and having 14 years of experience in development and migration project using Informatica tools. I have real time experience in Informatica tools like Informatica PowerCenter, Informatica Data Quality & Analyst, Informatica B2B DT, Informatica B2B DX, Informatica Mapping Analyst, Informatica Mapping Visio.

I have started teaching from last 8 years on Informatica and its tools. I have giving training around 250+ students online, offline, corporate training and freelance interviewer for MNC's. I have real time experience in Informatica related software's installation and configuration of services like Domain, PowerCenter Repository Service, Integration Service, Model Repository Service, Data Integration Service, Context Management Service (CMS), Analyst Service, Metadata Manager Service on both window and Unix platform.

All my training will be theoretically cum practical (50-50), this courses includes Datawarehousing concepts and ETL concepts.
No reviews currently Be the First to Review

About the Course

IDQ - Informatica Data Quality:



  • This is 32 hours of course to Informatica Data Quality 9.x/10.x through lecture and hands-on exercises (50% theory and 50% hands include admin console & admin task).

  • The course is designed for Developers who are new to Informatica Data Quality.

  • Informatica Developer is a thick client workbench tool that developers can use to profile, cleanse,

  • standardize, de duplicate and consolidate data in an enterprise.

  • The course will introduce attendees to working with the Developer Tool, performing tasks such as creating projects and objects, profiling data and identifying anomalies.

  • It will cover developing mappings and mapplets for use in processes such as data standardization, address validation, identifying duplicate records and consolidation.


IDQ - Course Objectives:



  • Navigate the Developer Tool and collaborate on projects with Analysts

  • Perform Column, Rule, Multi object, Comparative and Mid-Stream Profiling

  • Manage reference tables

  • Design and develop Mapplets

  • Create standardization, cleansing and parsing routines

  • Validate addresses

  • Identify duplicate records

  • Build mappings used to associate and consolidate matched records

  • Create and execute Workflows to populate IDD user inboxes with Exception and Duplicate record tasks.

  • Run data quality mappings in Standalone DQ and PowerCenter


IDQ - Target Audience:



  • New users of Informatica Developer, including Business and Data Developers.

  • Users who wish to re-familiarize themselves with the Developer tool


IDQ - Course Details:


This course can be delivered through Online instructor led format, which is comprised of 14 modules. The course introduces the students to the recommended data validation and testing methodology specifically for Data Validation Option, automatic test generation, reporting, and trouble-shooting.


 


Topics covered include



  • Profiling, Standardization and Address Validation

  • Matching and Consolidation Techniques


Course Objectives


On completion of this course Attendees will be able to:


Navigate the Developer Tool and collaborate on projects with Analysts using the Analyst Tool



  • Perform Column, Rule, Join, Multi object and Mid-Stream Profiling, LDO Read/Write, Score-card

  • Manage reference tables in the Analyst Tool

  • Design and develop Mapplets

  • Create standardization, cleansing and parsing routines

  • Validate addresses

  • Identify duplicate records

  • Build mappings used to associate and consolidate matched records


Course Agenda


Introduction to Data Quality Management


Unit 1: Working with Informatica Developer 9X/10X



  • GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects


Unit 2: Analyst Collaboration



  • Reviewing information from the Analyst

  • Comments/Tags

  • Creating/adding to Reference tables


Unit 3: Developer Profiling



  • Join Analysis Profiling

  • Column Profiling

  • Multi Object Profiling

  • Mappings and transformations

  • Mid-stream profiling

  • Comparative profiling


Unit 4: Data Standardization



  • Cleanse, transform and parse data

  • Develop data standardization mapplets and mappings


Unit 5: Address Validation 



  • Reusable AV Transformation

  • AV Transformation Properties

  • AV Inputs and Outputs

  • Reusable AV Mapplet


Unit 6: Matching



  • Grouping data

  • Analyze Detail Report

  • DQ Matching

  • Cluster Analysis Report

  • Matching Mapplets


Unit 7: Identity Matching 



  • Build Matching mappings using Identity matching

  • Identity Populations and Strategies


Unit 8: Consolidation & Key Generator



  • Associate and Consolidate data


Unit 9: Data Quality Assistant 



  • Build Mappings to create and populate the DQA tables

  • Perform manual Consolidation and Bad Record Management


Unit 10: PowerCenter Integration 



  • Export DQ Mapping to PowerCenter

  • Run DQ Mappings/Mapplets in PowerCenter


Unit 11: Object Import/Export 



  • Import Projects using both Basic and Advanced methods

  • Export Projects

  • Deploying DQ Jobs to Application


Unit 12: DQ for Excel 



  • Run Data Quality Mappings on Excel Spread sheets


Unit 13: Parameters



  • How to use Parameters in Data Quality mappings, transformations and reference tables


Unit 14: Content



  • What content is available with IDQ 9X/10X?

  • Content Management Service

  • Accelerators

  • Core Accelerator


Project



  • Use all that has been covered and apply it to Product Data 

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

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

Enquire

Submit your enquiry for Informatica Data Quality - IDQ

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Kamle

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 the OTP sent to your registered mobile number.

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

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