To Define Extraction Conditions and Validation.

1. Open the collaboration you want to edit.

2. Right-click the source table and click Properties.

   The Properties panel appears. By default, the extraction type is configured for conditional extraction. To leave the source data unfiltered, set the Extraction Type property to Full Extraction.

3. To define extraction conditions, click the ellipsis button next to the Extraction Condition property.

   The Extraction Condition dialog box appears.

   

4. Define the condition by dragging columns and operators onto the canvas, and then click OK.

5. To define validations for extraction, click the ellipsis next to the Validation Condition property.

   The Validation Condition dialog box appears.

   

6. Define the condition by dragging columns and operators onto the canvas, and then click OK.

7. To specify that only unique records be extracted, select the check box next to Select Distinct. To extract all records regardless of duplication, deselect Select Distinct.