DSXchange

Pratap (chotu) nicknamed me that. Seems appropriate. Thats my favorite role in life. I am very close to my sister's kids (now 21 and 24).

Wonder when someone would notice. Beats guru any day.

I agree with Craig. Even if you need to recompile then that is not a big problem. You can automate that.

You can routines that will work on both. Most of the routines in EtlStats work on both. The jobs do too. Paths are the main issue within jobs. Switching / to \.

There is a tutorial which comes with DataStage. Try that.

I do not think you can use the automated conversion from 3 to 7. You may have to convert to 4 then 5 then 6 then 7 or something similar. I doubt if you convert more than 2 versions at a time. I would think rewriting the jobs maybe the only possibility.

DataStage is one word.

ray.wurlod wrote:you're screwed

I would not want to go against that kind of statement from Ray.

I forgot: m Sample: m I wish I could show the real reports where the fact table matches to the penny on several columns in the fact table. The trending reports are pretty cool as well. If you are a dot com then is your revenue up or down based on a daily average sales. How important is that to your ...

If your customers like this as much as mine then you will be very happy. I thought about turning this into a product. I may still automate the tables needed for the reports. It will be easy to populate from any mapping table. Post a couple of your source tables and target tables and I will show you ...

I created a document to help people det this up. I have no way of explaining the importance of communicating to your users the accuracy of your data warehouse esecially a datamart. These simple QA completeness reports will build customer confidence in your accuracy. Please try to set this up if you ...

You can use this logic to create solid restartability. I hope that is what you are doing here. If a job has been run successfully today then skip it or do not run it again.

I printed this shell script to give Craig some ideas on restartability within Control M.

If anyone is using EtlStats then you can even do this in a shell script. LastRun=`$DSPath/dssh "LIST JobStatusLastRun '${RealJobName}' EVAL \"convert('-', '', field(@RECORD<4>, ' ', 1))\" ID.SUP COL-HDR-SUPP" | awk '{ if (NR==4) print $1
...

Try the tutorial.

PNav is Parameter Navigator. It is cheap and will help you manage all parameters and their values.

Try http://www.dsxchange.com/viewtopic.php? ... ht=Search1