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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+60- Celebrity
- 3701 replies
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
+60- Celebrity
- 3701 replies
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.