KeyGen Transformation



Characteristics

  • Is used in Conjunction with Match Transformation, where Match Transformation needs some ports from KeyGen.
  • Based on the strategy Used, it will create Key which Match Transformation can use to compare data. All the records with the same Keys will be compared by Match Transformation, this leads to better performance of Match  Transformation.
    • For e.g. All names Like Ramit Girdhar and Remit Girdhar and Ramit Gerdhar will have the same key generated by Keygenerator if we use Soundex. Now match transformation only have to compare records with the same Key.
  • Always Generate the Same Key for Same Values
  • Also, used in scenarios where an incoming source doesn't have a Key.

Different Strategies to Generate Keys
  • String
      • Just concatenation of Eaxct Strings
  • Soundex
    • Uses Phenotic to generate Keys, Fuzzy Matching.
  • NYSIS
    • NYSIS consider all vowels in the string as compared to Soundex which considers only 1st vowel in the string.
    • It Converts all letters to one of 6 characters and converts most vowels to letter A.
Transformation Specific Ports
Sequence ID
Group Key -- could be used as your New Key, if the incoming source doesn't have a Primary Key.

Comments

Post a Comment

Popular posts from this blog

IDQ - Data Profiling

To Analyze and Understand the Data. It is done using IDQ Analyst Web Client. Helps you understand the Data Quality and configure the Trust values accordingly in Informatica MDM Data Quality and Profiling Use the data quality capabilities in the Developer tool to analyze the content and structure of your data. You can enhance the data in ways that meet your business needs. Use the Developer tool to design and run processes that achieve the following objectives: Profile data. Profiling reveals the content and structure of your data. Profiling is a key step in any data project as it can identify strengths and weaknesses in your data and help you define your project plan. Create scorecards to review data quality. A scorecard is a graphical representation of the quality measurements in a profile. Standardize data values. Standardize data to remove errors and inconsistencies that you find when you run a profile. You can standardize variations in punctuation, formatting, an...
Read more

Labeler and Standardizer Transformation

Both are Used for Data Cleansing and Standardization for Addresses, Company Names(like LTD for limited, TAS  Trading As,). Labeler Characteristics Labels Different Incoming values e.g. #$^& as Symbols or S 017242 as 99999 Properties/Strategies Label using Reference Table Label Using Character Set. Standardizer Characteristics Used for Standardizing the Data e.g. AVE or AVE or AVNUE to AVENUE Properties/Strategies Offers Removal of Spaces. Label Using Character Set. Remove Reference Table Match Remove Custome String Replace Reference Table Matches with Valid Values Replace Reference Table Matches with Custome Values Replace Custome Strings.
Read more