About Data Quality Activities
Use the Data Quality activities in Studio to migrate or
load data into a new system and/or synchronize data between existing
systems.
Filter and Profile Activity
This activity filters data based on the Boolean expression
you create and generates a profile summary of the cleansed data.
Creating Profile Summaries
Use the Profile Summaries pane to specify parameters that
determine the data that the Integration Appliance profiles.
Filtering Expressions
A filter expression is an XPath query that specifies conditions
(boolean expressions) that the Integration Appliance uses to route
data to different outputs. You can create a filter expression using
the Filter and Profile activity.
Lookup Activity
Use the Lookup Activity to retrieve rows of data from a
selected database endpoint and use values from those rows to replace
or add values to the current recurring element, based on an exact
or approximate match of values from the current recurring element
that is used as a key to perform the lookup.
Sort Activity
This activity allows you to sort inputs.
Merge Activity
Use the Merge activity allows to join two sorted inputs.
Both the left and right inputs must be sorted on a specified sort
key before you can merge or join inputs. You must specify at least
one sort key for both the left and right inputs. The Merge activity
resolves any duplicates.