What are the different Workflow/task status in PowerCenter?
December 25, 2018
DPI Settings in Windows
Informatica Power Center installation window settings
January 5, 2019
Show all

Transformations in Informatica Data Qulaity (IDQ)

Informatica Data Quality Transformations

Informatica Data Quality Transformations

Address Validator: Active or Passive/ Connected Verifies and enhances the accuracy of postal address records, and adds information that helps users to select the mail recipients and to deliver the mail.

Association Active/ Connected Creates links between the duplicate records that a Match transformation assigns to different clusters.

Aggregator Active/ Connected Performs aggregate calculations.

Bad Record Exception Active/ Connected Identifies records that might contain data errors, and loads the records to tables that an Analyst tool user can review and update.

Case Converter Passive/ Connected Standardizes the case of strings.

Classifier Passive/ Connected Writes labels that summarize the information in input port fields. Use when the fields contain significant amounts of text.

Comparison Passive/ Connected Generates numeric scores that indicate the degree of similarity between pairs of input strings.

Consolidation Active/ Connected Creates a consolidated record from records identified as duplicates by the Match transformation.

Data Masking Passive/ Connected or Unconnected Replaces sensitive production data with realistic test data for non-production environments.

Data Processor Active/ Connected Processes unstructured and semi-structured file formats in a mapping.

Decision Passive/ Connected Evaluates conditions in input data and creates output based on the results of those conditions.

Duplicate Record Exception Active/ Connected Identifies records that might contain duplicate information, and loads the records to tables that an Analyst tool user can review and update.

Expression Passive/ Connected Calculates a value.

Filter Active/ Connected Filters data.

Hierarchical to Relational Active/ Connected Processes hierarchical input and transforms it into relational output.

Java Active or Passive Connected Executes user logic coded in Java. The repository stores the byte code for the user logic.

Joiner Active/ Connected Joins data from different databases or flat file systems.

Key Generator Active/ Connected Assigns records to groups based on data values in a column that you select.

Labeler Passive/ Connected Writes labels that describe the characters or strings in an input port field.

Lookup Active or Passive Connected or Unconnected Look up and return data from a flat file, logical data object, reference table, relational table, view, or synonym.

Match Active/ Connected Generates scores that indicate the degrees of similarity between input records.

Merge Passive/ Connected Reads the data values from multiple input columns and creates a single output column.

Normalizer Active/ Connected Processes source rows that contain multiple-occurring data and returns a target row for each instance of the multiple-occurring data.

Output Passive/ Connected Defines mapplet output rows.

Parser Passive/ Connected Parses the values on an input port into separate output ports based on the types of information that the values contain.

Rank Active/ Connected Limits records to a top or bottom range.

Read Passive/ Connected Reads data from a source.

Relational to Hierarchical Active/ Connected Processes relational input and transforms it into hierarchical output.

REST Web Service Consumer Active/ Connected Connects to a REST web service as a web service client to access or transform data

Router Active/ Connected Routes data into multiple transformations based on group conditions.

Sequence Generator Passive/ Connected Generates a numeric sequence of values.

Sorter Active/ Connected Sorts data based on a sort key.

SQL Active or Passive Connected Executes SQL queries against a database.

Standardizer Passive/ Connected Generates standardized versions of input strings.

Union Active/ Connected Merges data from different databases or flat file systems.

Update Strategy Active/ Connected Determines whether to insert, delete, update, or reject rows.

Web Service Consumer Active/ Connected Connects to a web service as a web service client to access or transform data.

Weighted Average Passive/ Connected Reads the match scores that a Match transformation generates for the records in a data set, and calculates an average score for each pair of records. You can apply different weights to the scores that the transformation generates for each pair of records.

Write Passive/ Connected Represents a target that the mapping writes data to.

Comments are closed.

Share
+1
Tweet
Pin
Share