Compare database table schema before and after metadata update
Hello,
assume we have a defined database table "a" schema (col1 numeric, col2 numeric, col3 numeric).
Now the source table "a" gets modified in the source system, so i have to update metadata in Talend Studio via "Edit Schema" -> "Retrieve Schema"
The schema itself gets updated, but how can i see the actual changes before and after updating, so that i can make the adjustments in the job accordingly?
Currently i need to ask the datasource owner what the changes were (new column added, changed datatype, removed column)
Q1: Is there any way to compare old and new schema?
Q2: Any possibilty to see how the schema update affects existing jobs and components, so i can work through all single jobs step-by-step?
