DSXchange

kduke

Columns more closely relates to lines of code. Do a search on complexity. We have had several discussions on it.

kduke

Either works. It is a matter of preferrence. It is also a performance issue. Hashed files are faster but they take some time to build. If you add up the overall times for both then that should be your deciding factor. The fewer rows in the dimension the faster it loads. So I would say until you get ...

kduke

Mike is correct. You may want to count links, columns, routines and whatever else that takes time. Columns would be very difficult.

kduke

I would change these jobs to read csv files. Save the spreadsheets as csv files. Make your life easier.

kduke

There are examples. There are complete shell scripts with examples. Not sure why you are doing an eval.

Try this:

Code: Select all

$DsjobPath/dsjob -server $UX_SERVER -user $UX_USER -password $UX_PWD -run -mode NORMAL -param PRM_TRT_DT="$TREAT_DT_END" -jobstatus $PROJECT $SEQ

kduke

Good to know.

kduke

Job control is valid as well as batch job.

kduke

Code: Select all

Select 
   Count(*) As Cnt
From 
   DS_JOBS
Where
   NAME NOT LIKE '\%'
;

Code: Select all

Select 
   Count(*) As Cnt
From 
   DS_JOBOBJECTS
Where
   OLETYPE LIKE '%Stage'
;

kduke

DataStage is setup normally so all developers are in one UNIX group like dstage including dsadm. This group needs to read and write to each others files so the umask needs to be 002. The group id is set on these directories so that each user in this group can delete the other users files. So there i...

kduke

I would pick server because he is on Windows but his profile also says parallel.

kduke

Please post your code. It looks like a syntax issue.

kduke

Please edit your post and put code tags around your program so we can see the indentation.

kduke

The report is called DsHashFilesFind.sql in EtlStats. You can run it with job GenHtmlFromSqlDriver. You need to put the hashed file name in parameter Replacements. Here is the SQL to run at TCL if you like: select DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE, DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS...

kduke

MetaStage is supposed to have a job diff. HAWK is supposed to have a much better diff. You can do it in Reporting Assistant with an Access report if you want to build your own.

kduke

The default is 768.

Search found 4605 matches