Skip to content

Matt Masson

SQL Server Integration Services (SSIS), Power Query (PQ), Azure Data Factory (ADF), and general Data Integration

DQS – Using the Changes History Panel

  • Home
  • 2012
  • March
  • DQS – Using the Changes History Panel
Data Quality Services, Quick Tip MattMarch 27, 2012

The DQS client will automatically sort the list of Domain Values, which can make adding new values to a big list tricky. Once you enter the new value at the bottom of the list, it gets automatically sorted, and you need to scroll up the list to find it again. However, there is a better way!

At the far end of the toolbar, there is a drop down button which exposes the lesser used commands. One of these is the ShowHide domain values changes history panel button, which turns out to be incredible useful.

Domain Values Changes History panel button

When the panel is enabled, it is displayed at the bottom of the Domain Values page. When a value is added or modified, the change will be displayed in the log window, with a hyperlink to the domain value. Clicking on this link will automatically scroll/focus on the list to the target value.

image

DQS

Post navigation

Microsoft SQL Server 2012 Integration Services
SSIS Performance Design Patterns

Copyright © 2021 | All Rights Reserved. CorpoNotch by Shark Themes