Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?

Question

Options

• AThe Data Validation transformation can generate match codes to provide de-duplication
• BThe Data Validation transformation can perform missing-value detection and invalid-value
• CThe Data Validation transformation provides de-duplication capabilities.
• DThe Data Validation transformation provides error-condition handling.

• A
  89% (24)
• B
  4% (1)
• C
  7% (2)

Explanation

Option A is correct because generating match codes for de-duplication is a feature of the Match Merge or Identify Duplicates transformation in SAS Data Integration Studio - not the Data Validation transformation. The Data Validation transformation focuses on checking data quality rules, not creating phonetic or fuzzy match codes.

Why the distractors are wrong:

• B is a real feature - Data Validation does detect missing values and flags invalid values against defined rules.
• C is a real feature - Data Validation can identify and handle duplicate records as part of its cleansing capabilities.
• D is a real feature - Data Validation lets you route or handle records that fail validation checks (error-condition handling).

Memory tip: Think of Data Validation as a quality inspector - it checks, flags, and routes bad data (B, C, D). "Match codes" (A) belong to a matching/deduplication specialist tool, which is a separate transformation. If the answer mentions a specialized technique like match codes, it's likely pointing to the wrong tool.

No community discussion yet for this question.