Page 1 of 1
Compare two Datastage jobs
Posted: Wed Jul 29, 2009 5:41 am
by monaz
Hi All,
Can anyone please let me know is there anyway we can compare two datastage jobs?
Posted: Wed Jul 29, 2009 5:45 am
by Sainath.Srinivasan
For v7,
Take export and do a diff.
Posted: Wed Jul 29, 2009 6:30 am
by chulett
In other words, it's a manual process. Export both to a .dsx and compare using your favorite tool. This is automated in 8.x.
Posted: Wed Jul 29, 2009 2:39 pm
by cppwiz
The Cross Project Compare tool in 8.x is quite nice. Just highlight the job in the repository list and click on the Repository menu then Cross Project Compare and select the other job. It gives a detailed report of the differences.
Posted: Wed Jul 29, 2009 2:43 pm
by nagarjuna
Unfortunately it will take some time to produce the difference
Posted: Wed Jul 29, 2009 4:40 pm
by ray.wurlod
Minutes rather than hours. Learn patience, grasshopper.
Posted: Wed Jul 29, 2009 8:19 pm
by sbass1
This is a long shot, but...
Before I reinvent the wheel (ok, maybe this request isn't as common as a wheel!), has anyone developed any Beyond Compare user-configurable rules to ignore unimportant differences between DSX files? Examples might be:
* VC LOGS *
^1_1 05/26/09 14:03:57 Batch 15122_50672 INIT foddev9 DEV_XXX userid Initialize
added to the job description by the version control tool
TimeModified "some-time"
Readonly "some-value"
etc.
If so, I'd love to get an export of your rules...
Thanks...
P.S.: DS 7.x, Server, Unix
Posted: Thu Jul 30, 2009 8:29 am
by nagarjuna
ray.wurlod wrote:Minutes rather than hours. Learn patience, grasshopper. ...
I understand ray ...But when i wrote a batch script to compare jobs its taking long time ...for comparision of 10 jobs across twp projects it took nearly 4 hrs
Posted: Thu Jul 30, 2009 4:27 pm
by ray.wurlod
Yes, that's minutes. 48 minutes each, on average.
There's a lot of work to do to compare every object and every relationship.
Posted: Fri Jul 31, 2009 6:21 am
by priyadarshikunal
Its not the comparision command which is taking long time, probably it your network connection/server/client system which is taking long time. On my system it compares around 100 jobs with another 100 on other server per hour. Of course it depends on the complexity of the job but you shouldn't complain about the time taken to compare the jobs.
Posted: Sun Aug 02, 2009 7:30 am
by Sreenivasulu
Cross project compare is an excellent feature of version 8. This was a very tedious and manual process in earlier versions.
Regards
Sreeni
Posted: Tue Jul 31, 2012 6:11 am
by kurics40
nagarjuna wrote:... when i wrote a batch script to compare jobs its taking long time ...
Hi Nagarjuna,
Can you show me your batch script?
I dont know how to invoke the compare tool from command line.
Best regards,
Janos
Posted: Tue Jul 31, 2012 6:36 am
by chulett
kurics40 wrote:I dont know how to invoke the compare tool from command line.
Oddly enough, it's fully documented. Designer Client Guide, Chapter 9.
Posted: Tue Jul 31, 2012 6:54 am
by kurics40