Skip to main content
Question

Change Detector , dynamic schema

  • October 26, 2019
  • 2 replies
  • 74 views

boubcher
Contributor
Forum|alt.badge.img+11

Hello there

Is there a way we could apply the change detection but reading dynamically each orgine and revised input , because we have a large number of table to check

 

Thanks

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.

2 replies

david_r
Celebrity
  • October 28, 2019

Sure, just make sure that the "Update detection key attributes" contain something that allows the transformer to know which Original feature is to be compared to each Revised feature to avoid comparing across tables. If you're comparing two different databases with the same schema, this could e.g. be table name.


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • November 1, 2019

Sure, just make sure that the "Update detection key attributes" contain something that allows the transformer to know which Original feature is to be compared to each Revised feature to avoid comparing across tables. If you're comparing two different databases with the same schema, this could e.g. be table name.

@david_r

thanks will do , will see how it goes