01-14-2018 10:47 PM
Is there any way to compare two DI studio jobs in DI Studio 4.2? I've two jobs - one which has 12 transformations and the other job was updated from the first one and it has 14 transformations. Instead of manually comparing the transformations and tables which was being used in the jobs, can we do it in other way (if it is available)?
01-15-2018 05:00 AM
01-16-2018 09:24 AM
I don't have access tool right here, but you are prompted for comparison at least when importing metadata (and importing SAS package metadata as well if I recall right) and wish to overwrite existing objects.
01-15-2018 05:06 AM
In the past I've copied and pasted the code for the whole job and pasted into column A of an Excel worksheet. Then done the same for the other job, pasting into column C. Then in cell B1 I insert the formula =A1=C1 and then copy that all the way down. Then I put a filter on column B and filter for FALSE. Where the code is different you may need to insert blank lines into one or the other in order to keep them in step, and then recopy the formula down. There will be lines which are only different because they came from different jobs - these should be easy to spot.
Or, you could use something like WinMerge to compare the two sets of code.
But I don't think there is anything more elegant.