locked
How can I verify the data existing in the reference table? RRS feed

  • Question

  • Hello DQS Expert, 

    Here is the question, guess it should be a frequently-asked one. How can I make sure the import data, e.g. Subcategory, the values of sub-Category exist in the reference table  "dimSubCategory". I know there is a feature called "domain values" but once it is imported, it is static. How can I know what values have been added to my reference table(dimension table)? How can the imported data verified against what is in that table? 

    This should be a common feature and very useful. Not sure whether I missed something in DQS or it doesn't have this feature to check the domain values against a table. If it doesnt have this feature, will feel a little bit weird. 

    Please shed some lights on, thanks


    Derek

    Thursday, July 16, 2015 3:35 AM