DSXchange

I need to set up cron entries for DS. Im doing it as below for differenct Sequences. I hope this is correct else pl. suggest. 10 19 * * * . Job1DSRun.sh > Job1DSRun_OP 10 20 * * * . Job2DSRun.sh > Job2DSRun_OP 10 21 * * * . Job3DSRun.sh > Job3DSRun_Op Or would this be more functional? 10 19 * * * ./...

What do the the below featues in a Job Seq do if checked?
1. Add checkpoints so sequence is restartable on failure??
2. Automatically handle activities that fail??
Thx

I have two job sequences created. I will need to run the second sequence based on the return value of the first from command line.
How do I kick of the second job from the script based on the return value of the first kick off.
Thanks

We are using SQL server as target for DS and unicode datatypes - nchar, nvarchar. Our "project default map for stages" is set to Project default (ISO-8859-1) and "Default collation locales" for stages is set to OFF. Do we need to set to anything else from defailt and OFF to handl...

We moved data from JDE DB2 whose type was CHAR into Sql Server NCHAR. SQL server uses 2 bytes for NCHAR and NVARCHAR. If CHAR 10 needs to be moved into NCHAR10 then what is the right lenght in Datastage for table def- A. CHAR10 to NCHAR10 (OR) B. CHAR10 to NCHAR20 If I was performing a lookup on NCH...

I did not use sort, hash partition by key columns on the join. Rather left to default auto and ran. There were some data columns that came in with a blank values on the left join. I then changed it to sort,partition and data columns came in right without any blank values. I checked my data for testi...

On the DB2 end you have a primary key o n the column.

Load_D_GLobal_Items,1: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:171] Load_D_GLobal_Items,0: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:171] Load_D_GLobal_Items,3: Operator terminated abnormally: received signal SIGSEGV [...

My target dB is SqlServer. Whats a good way to convert blank source data to nulls?

We need to use the correct optimized method in our ODBC stage. Our environment- 4 CPUs Solaris. 1. We read from two types of tables - source, ref tables. Our source table gets loaded with 2k rows everyday and cleaned every 2 months(120k max accumulation in 2months). Our REF tables wouldn't exceed 1k...

We need to use the correct optimized method in our ODBC stage. Our environment- 1. We read from two types of tables - source, ref tables. Our source table gets loaded with 2k rows everyday and cleaned every 2 months(120k max accumulation in 2months). Our REF tables wouldn't exceed 1k rows. 2. There ...

Cluster key change column in aggregator stage. Im not finding it. Can someone pl. point me to it.
Thanks

Is there a way in v8 Information Server where we could connect to DS Server box from a remote box and run ds job run command?
Can I run something like
dsjob run -server -port project name server name?
Thanks!

I have a job with two column names ename - table1, ENAME- table 2.
They both have the same length. Is it necessary to convert the names. Im assuming that as long as the types and lengths are sames we can perform a lookup between two columns.
Thanks!

Im trying to run my job from command line through the command "dsjob" 1.I have created my job params file under location- IBM/InformationSerer/Server/DSEngine/dsparams1.txt' 2. Im trying to run it with the syntax - dsjob -run -mode NORMAL -param file='IBM/InformationSerer/Server/DSEngine/d...