A. creates a single, consolidated record from records identified as possible duplicates by the Match transformation

B. a transformation which is found only in PowerCenter

C. an active transformation

D. a passive transformation

A. Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

B. Only mappings using non active transformations can be used in DQ for Excel.

C. All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

D. All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

A. Edit Distance

B. Hamming Distance

C. Jaro Distance

D. Bigram

A. DQ for Excel allows .xls files be used as source and target objects in mappings.

B. In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.

C. DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/worksheets.

D. DQ for Excel can be used in any version of Excel.

A. From the Mapping menu, select Add Transformation

B. Double click on the transformation in the transformation palette

C. Right click and choose Add Transformation on the mapping

D. Click and drag the transformation onto the mapping

A. Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.

B. Change the code page of the file to UTF-8.

C. Import the fileinto a database table before profiling.

D. Allow the wizard in Developer to automatically select the data types when creating the data objects.

A. At the end of the process only to prove the value of the data quality tool

B. Not at all - Scorecardlng is a separate process

C. At the start of the process only to assess current data quality levels

D. At the start and during regular intervals of the process to measure on-going data quality levels