Data360 Analyze

 View Only
  • 1.  Lookup duplicateLookupKeyBehavior Log location

    Posted 12-06-2019 12:29

    On the lookup node there is an Exception Behavior option duplicateLookupKeyBehavior and one of the 3 values in the dropdown is Log

    Log - A warning is logged for the first duplicate value encountered. Records from the main input will only ever match the first of the duplicates in the lookup input.

    Where is it logged? What information is logged? 



  • 2.  RE: Lookup duplicateLookupKeyBehavior Log location

    Employee
    Posted 12-09-2019 11:14

    The base information for the warning message is contained in the node log file for the Lookup node. The node log files are stored in a sub-directory of the Analyze instance's site directory at:

    site/data/executions/<username>/<dataflow name>/<run uid>

    The folder will contain the intermediate data for the nodes in the data flow execution and the corresponding log file for each node.

    The log file only identifies the first occurrence where a duplicate key use was detected.  

    The error message indicates (for the first occurrence only) the record number on the 'lookup' input that contains the first instance of the the duplicate key and the corresponding record number on the 'lookup' input containing the duplicate key.

    The log also details the metadata for the 'data'  and 'lookup input pins, and the output metadata.

    Note. if there are multiple key values that have duplicates on the lookup pin these other duplicate occurrences are not logged.