view to filter the records that the transformation writes as output. Configure the property when you specify index data tables and you select a clustered output format. Filter the records to limit the output to clusters that contain one or more records from the data source.
You can filter the output data in the following ways:
Write every cluster that includes a record from the data source or the index tables
Select
All Rows
. The transformation writes every cluster that contains at least one record from either the data source or the index data store. The default is All Rows.
Because a cluster can contain a single record, the output contains all records.
Write every cluster that includes a record from the data source
Select
New and Associated Rows
. The transformation writes every cluster that contains at least one record from the data source.
Because a cluster can contain a single record, the output contains all records in the data source. The clusters can also include records from the index tables.
Write every cluster from the data source
Select New Rows Only.
The transformation writes the clusters that contains records from the data source. The output does not contain any record from the index tables.
ASK INFAPreview
