What transformation would you use to standardize data using a reference table?

Answer(s): C

A customer has provided a number of delimited flat files that require profiling, but not file definition. What should you do first?

Options are :

Allow the wizard in Developer to automatically select the data types when creating the data objects.
Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
Import the file into a database table before profiling.
Change the code page of the file to UTF-8.

Answer(s): A

With respect to field matching in IDQ, which best describes the approach to address matching?

No standardization is necessary, map input fields to the match transformation
Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation
Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation
Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Answer(s): D

Which transformations can be used in DQ for Excel?

Only mappings using a Case Converter and a Standardizer can be used on data in Excel.
Only mappings using non active transformations can be used in DQ for Excel.
All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.
All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

Answer(s): D

Free DATA-QUALITY-10-DEVELOPER-SPECIALIST Exam Braindumps (page: 2)