SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Compare DI Jobs

Reply
Super Contributor
Posts: 625

Compare DI Jobs

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)?

Super User
Posts: 5,853

Re: Compare DI Jobs

I don't think that comes OOTB. Tables and files can be compared with built in function.
Depending on your preferences exporting the code to a text comparison tool might be the simplest?
Data never sleeps
Super Contributor
Posts: 625

Re: Compare DI Jobs

Could you please help me understand how can I compare tables and files with
build in function?
Super User
Posts: 5,853

Re: Compare DI Jobs

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.

 

Data never sleeps
Occasional Contributor
Posts: 19

Re: Compare DI Jobs

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.

Ask a Question
Discussion stats
  • 4 replies
  • 221 views
  • 2 likes
  • 3 in conversation