Skip to main content
Question

Change Detector , dynamic schema


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

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
david_r wrote:

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings