Informatica IDQ

Bad Record Exception Duplicate Record Exception

A Match Output System Ports  - When Clusters selected  ClusterID GroupKey ClusterSize RowID  -- Source Record ID. DriverID   -Maximum record ID in that Group DriverScore   --- Maximum RowID in Group act as a Trigger record LinkID  -- Minimum Record ID in that Group LinkScore  -- Confidence Level -- in link score lowest RowID in Group act as a Trigger record System Ports  - When Matched Pair is selected  GroupKey RowID RowID1 DriverScore Match Type Field Match(Single Source) Strategies Field Matching Bigram Distance Edit Distance Hamming Distance Jaro Distance Reverse Hamming Distance Identity Matching

Its a passive transformation Is used to concatenate fields.

You can use regex to validate/Standardize the data.

Introducing Informatica Analyst  Informatica Analyst is a web-based application client that analysts can use to analyze, cleanse, standardize, profile, and score data in an enterprise. Depending on your license, business analysts and developers use the Analyst tool for data-driven collaboration. You can perform column and rule profiling, scorecarding, and bad record and duplicate record management. You can also manage reference data and provide the data to developers in a data quality solution.

Informatica has a service-oriented architecture that provides the ability to scale services and to share resources across multiple machines. The Informatica domain is the primary unit for the management and administration of services. You can log in to Informatica Administrator after you install Informatica. You use the Administrator tool to manage the domain and configure the required application services before you can access the remaining application clients. Application Client Application Services Repositories Informatica Analyst - Analyst Service Model repository - Content Management Service - Data Integration Service - Model Repository Service - Search Service Informatica Developer - Analyst Service Model repository - Content Management Service - Data Integration Service - Model Repository Service...

URL is http://servername:port/AnalystTool/