DSXchange

Thanks hullet

I found the log and control file, it says all the rows are successfully loaded, 0 rejected, in that case why this fatal error?

thanks..

I am getting the following error when trying to load into an ORCLE table using Load and Append, job_0001,0:The system(sqlldr CONTROL=ora.1306720.90647.0.log BAD=ora.1306720.90647.0.log.bad SILENT=header PARFILE= ora.1306720.90647.0.par) failed: see the log file for oracle specific message. To view t...

Signs of a corrupted project???

Looks like whole project, most of the jobs are throwing these errors.

Thanks.

I am started getting the following errors: when trying to run the lowest level jobs (parallel jobs). -cannot open executable job file RT_CONFIG97 -failed to open RT_LOG14 file -cannot open executable job file RT_CONFIG17 -cannot open RT_STATUS52. -failed to invoke GenRuntime using Phantom process he...

Thanks Hulett

But, There are no processes running as i see..

Hello guys, Seq_job0002..JobControl (@JS_01): Controller problem: Error calling DSAttachJob(Seq_0001) (DSOpenJob) Cannot open job Seq_0001. - not a runnable job getting the above error when running a sequence job, all the jobs which are called in the sequence job are finished/compiled/has been reset...

Thansks alot guys.. select to_char(nvl(max(col_date), to_date('10/10/2001 10:10:10' , 'MM/DD/YYYY HH24:MI:SS'))) as max_date from table_name; When i run this query in Toad returns with exact MAX date with time as well(08/14/2009 11:30:44) But datastage returns like this (08/14/2009 00:00:00). Datast...

Hello I was using the below query to select max date from source which alos have null values. select to_char(nvl(max(col_date), to_date('10/10/2001 10:10:10'))) max_date from table_name This is working fine from toad, but when used in OCI stage returned ORA-01843. nota a valid month. (i think i am c...

Thanks,

mekrreddy wrote:we have dev project running on DEV envi, now we are creating prod project in prod environment, question is how to export the envi variables and config file to the new prod project(with prod directories).

Thanks in advance.

we have dev project running on DEV envi, now we are creating prod project in prod environment, question is how to export the envi variables and config file to the new prod project(with prod directories).

Thanks in advance.

Is it possible to view the dataset from production environment(UNIX). using the command. $orchadmin dump [options] descriptorfile.ds.

Thanks in advance.
reddy.

From the data I see above you can specify contraints in transformer as

input.key1=1 or (input.key1=2 and input.col2='MFG')

Use the constraints in transformer and add logic where or use filter if you do not want use transformer, and also make sure there are no spaces in data

Do any one have an idea about implementing SCD type 3 in datastage V8.1 if it supports?