UrbanPro
true

Informatica Data Quality - IDQ

LIVE
5 Hours

Just Pay ₹200 to Register

- OR -

Course offered by Gowtham K

0 review

IDQ – Informatica Data Quality Course Content:
This course can be delivered through online instructor led format, which is comprised of 17 modules.
Topics covered include
 Profiling, Standardization, Data Cleaning using Labeler & Parser, de-duplication and Address Validation
 Matching and Consolidation Techniques
 Reference Table Management and its usage
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 Profile, Join Profile, Multi object and Mid-Stream Profiling, Mid-Stream data preview, LDO, Scorecard and working with DQ transformations
 Manage Reference Tables in the Developer & Analyst Tool
 Design Rule & Mapplet, Mapping, Wokflows and develop of Applications
 Create standardization, cleansing and parsing routines
 Identify duplicate records
 Build mappings used to associate and consolidate matched records
 Exception Process – Bad Records & Duplicate Records
 Validate addresses
Course Agenda
Introduction to Data Quality Management
Unit 1: Working with Informatica Developer 10X
 GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects, Reference Tables, LDO
Unit 2: Analyst Collaboration
 Creating Profile and Scorecards
 Adding Comments/Tags
 Reviewing information from the Analyst
 Creating/adding to Reference tables
 Creating Profile, Reference Tables
Unit 3: Developer Profiling and Logical Data Objects
 Perform:
o Column Profiling
o Join Profiling
o Mid-stream profiling
 Create a Logical Data Object
 Create Mappings and work with DQ and Core transformations
Unit 4: Labeler and Data Standardization
 Cleanse and transform data using Labeler and Standardization Transformations
 Develop data standardization mapplets and mappings
 Working with Reference tables
Unit 5: Parsing
 Perform parsing using a variety of methods such as:
o Token Parser
o Pattern Parser
o Working with Reference Tables
Unit 6: Field Matching
 Grouping data
 DQ Matching
 Match Cluster Analysis
 Matching Performance Analysis
Unit 7: Identity Matching
 Build Matching mappings using Identity matching
 Identity Populations and Strategies
Unit 8: Automatic Consolidation & Key Generator
 Associate and Consolidate data
Unit 9: Manual Exception and Consolidation Management
 Build and execute Mappings, using the Exception Transformation, to identify bad records and duplicate records.
Unit 10: Task and Workflow Management
 Build and execute workflows to populate Informatica Data Director user inboxes with exception and duplicate records
Unit 11: Informatica Data Director (Informatica Analyst)
 Update exception and duplicate records in IDD
Unit 12: PowerCenter Integration
 Export DQ Mapping to PowerCenter
 Run DQ Mappings/Mapplets in PowerCenter
 Build and execute a workflow in PowerCenter Developer using DQ mapplets.
Unit 13: Running DQ in a Standalone environment
 Schedule DQ mappings to run in DQ Standalone using Windows Task Manager
Unit 14: Object Import/Export to Informatica PowerCenter
 Import Projects using both Basic and Advanced methods
 Export Projects
 Deploying DQ Jobs to Application
Unit 15: Content
 What content is available with IDQ 10.X?
 Content Management Service
 Accelerators
 Core Accelerator
Unit 16: Parameters and Schedule
 How to use Parameters in Data Quality mappings, transformations and reference tables
 Scheduling Profile, Scorecards and Applications.
Unit 17: Address Validation
 Create a Reusable AV Transformation
 AV Transformation Properties, Inputs and Outputs
 Build and execute an Address Validation Mapping
 Reusable AV Mapplet

Gallery (1)

About the Trainer

Raj picture

Avg Rating

0 Reviews

0 Students

2 Courses

Gowtham K

B.Sc (Computer Science)

10 Years of Experience

I have been 15+ Years of IT experience in Datawarehousing using Informatica Tools PowerCenter, IDQ, Cloud, MDM and B2B DT&DX.

And also worked as Technical Architect & Solution Architect. I have been involved in analysis, design, development, testing and deployment phases for different projects. I

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Informatica Data Quality - IDQ by Gowtham K

Raj picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Informatica Data Quality - IDQ by Gowtham K

Raj picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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