Things to be considered while desinging a DS job

When you need to run the same sequence of jobs again and again, better create a sequencer with all the jobs that you need to run. Running this sequencer will run all the jobs. You can provide the sequence as per your requirement.   If you are using a copy or a filter stage either immediately after or immediately before a transformer stage, you are reducing the efficiency by using more stages because a transformer does the job of both copy stage as well as a filter stage  Use Sort stages instead of Remove duplicate stages. Sort stage has got more...

SQL Query Order of Operations:

SQL Query Order of Operations: Tags: SQL Lately, I have been looking into SQL query optimization. We recently installed SeeFusion on our server and I can see where my long running tasks are causing the server to slow down. Turns out, not surprisingly, that the slow pages are very query-intense. Granted, a lot of these pages were pages years ago before I knew what nice code looked like, but the good news it, lots of room for optimization and clean up. To start out, I thought it would be good to look up the order in which SQL directives get executed as this will change the way I can optimize: 1.                FROM...