Hi I tried Change Detector & Update Detector to compare records in 2 tables based on a unique key. Lets say input tables have 10 attributes in unchanged port output of change detection I get few records but attribute value of all except the unique key specified for comaprison is NULL. Is there anyway I can get attribute values in unchanged port as well As I need to do further processing based on these attribute values of Unchanged records.
Page 1 / 1
The reason they're set to null in your case is because they might be different if you're not selecting them for the matching. If you select all attributes to match on it should output them all.
The reason they're set to null in your case is because they might be different if you're not selecting them for the matching. If you select all attributes to match on it should output them all.
Hi the two tables I am comparing have only a unique key in common .As per business requirement after this comparison I will compare the output with another table which has all the attributes.Now since from first comparison I am getting NULL values I am using featuremerger to again fetch all the attributes from source data based on Unique Key ouput from Unchanged Port of change detector
Hi the two tables I am comparing have only a unique key in common .As per business requirement after this comparison I will compare the output with another table which has all the attributes.Now since from first comparison I am getting NULL values I am using featuremerger to again fetch all the attributes from source data based on Unique Key ouput from Unchanged Port of change detector
You could try an AttributeCompressor before and AttributeDecomressor after the change detection to avoid having to merge features, but that's about it.