DSXchange

I used to think an accountant knew the most about making a business successful. Because they understand finances therfore they know how to make a business successful. Most accountants think their job is done when debits equal credits. Most ETL developers think their job is done when it loads success...

Perkin-Elmer, I have not heard that name in 20 years. Progress can easily dump to tab or comma delimited files but you need a programmer. Progress has arrays in columns or multivalues if you will. So good luck.

Thanks Roy. DwNav will allow you to trace from link to link and job to job.

Okay. This is not totally accurate but close enough for your sake. select EVAL "FIELD(@ID,'.',1)" AS JOB_NAME FMT '35L', EVAL "FIELD(@ID,'.',2)" AS INSTANCE_ID FMT '35L', EVAL "@RECORD<2>" AS STATUS_CODE FMT '3R', EVAL "field('Running-Finished-F...

You can figure out the category. Change :1 into your job number. select EVAL "FIELD(@ID,'.',1)" AS JOB_NAME FMT '35L', EVAL "FIELD(@ID,'.',2)" AS INSTANCE_ID FMT '35L', EVAL "@RECORD<3>" AS START_TIME FMT '23L', EVAL "@RECORD<4>" AS END_TIME FM...

The patch from IBM fixed our problem.

I would wrap your script in a bat file and see if it works. If it does then run it that way in DataStage. Next when you use a command stage then it will not pass parameters. In the batch file echo the parameters passed to it to make sure it is getting them. This should show up in the log. There is a...

The dsjob command can produce a XML file with row counts and parameter values. Both are repeating. So it is a good way to learn how to parse XML. The job DSJobReportDb included with EtlStats does exactly this. It parses the XML from dsjob.exe or dsjob in UNIX. It parses all the repeating groups sepa...

This is done in several jobs included in EtlStats. Most of these are used in reports. The QA jobs will calculate one measure and store it in a table. There is one measure for a source table and one for the target table then these are compared in a report to show completeness of the data warehouse lo...

The new EtlStats is Windows based. I not sure exactly what you want to run in Windows. Can you be more specific?

You can see how DwNav works by watching <a href="http://www.duke-consulting.com/DwNav/DwNavDemo.html" target="blank"> this.</a>

DwNav does a lot more than this demo but it will get you started.

Awesome. Thanks Ken. That is what I was wanting to hear. Hopefully more people will jump in. I think some may disagree with some of your answers. Star schema is there for performance. If you vary a lot from a star schema then your performance may suffer. Users may like the information but a redesign...

Only me and Ray have observed a data warehouse failure? Don't name the customer just tell us what went wrong. Surely there are some situations where we could all learn from. Share with us your experiences. Maybe you have a great experience. Share that. We would all like to duplicate a great experien...

DataStage has to know when this script is finished and either fails or is successful.

You might want to change it into a exe or put it in a bat file.

I would think another problem is that the script is not releasing the file so DataStage cannot open it.

Nice article. Good job Ray.