DSXchange

It's clearly not ignoring your load options as your errors allowed is being set to what you specify. This setting is more likely to tell the loader how many records it should allow through before falling over. Have you got a reject link out of the Oracle stage? As I mentioned in my first post,I am ...

This is what is reported in the datastage log The call to sqlldr failed; the return code = 2; please see the loader logfile: /export/home/dsadm/Ascential/DataStage/Projects/scratch/ora.6483.383524.6.log for details. Since the return code is 2 is this a warning from sqlldr,but still datastage aborts ...

Hi, I am using oracle load option to insert records in the table. Since my source can have duplicates/or target table is huge to check against input for existing records. Hence I am using ERRORS parameter of sqlldr to ignore the errors and continue to load good records. The options I am passing are ...

And also define what you mean by "startup time". For the job to say that it is "started"? Or perhaps log the "Initiated" entry? For an initial query to start returing rows? What? ... I am seeing the log and thats where i get the startup time and run time..the job doesn...

And also define what you mean by "startup time". For the job to say that it is "started"? Or perhaps log the "Initiated" entry? For an initial query to start returing rows? What? ... I am seeing the log and thats where i get the startup time and run time..the job doesn...

Hi I have couple of jobs in my sequencer that are taking un usually high start up time( ~ 8 min) irrespective of number of records in the transaction.. the run time is very short say 20 secs etc..What could be the reason for this high start up time? The job is not complex..couple of look ups and a t...

dipanzan wrote:Reading the file as a DOS fomatted file might have solved the problem..

Thanks for reminding, I completely forgot about that.been a while i handled dos files :D

dipanzan wrote:Reading the file as a DOS fomatted file might have solved the problem..

Thanks for reminding, I completely forgot about that.been a while i handled dos files :D

found the issue. its due to 0d hex in the column, took left(col,length(col)-1) and used that as input to stringtodecimal function.

Sainath.Srinivasan wrote:StringToDecimal with trunc_zero ?

I guess thats the default.

Even i specify it or not, i don't see any difference.

When i hard code some string like "1234.456" in the StringtoDecimal, it works fine,but it doesn't work with my input

Hi

I am reading a file with decimal vales in a column. Reading the column as vachar.

Record 1 : col: 70.4582
Record 2 : col : 1.234 etc

Using StringToDecimal with trunc_zero. and writing to peek as 10,7

I see the output always as 000.0000000

Hi,

Is there a function in parallel transformer to get days between 2 timestamps?

There is a function to get between 2 dates, but it ignores time portion..

Can anyone help?

Hi, I am using XMLInput stage to process XML files. The meta data is Huge around 1000 columns. The throughput is very bad, i get around 30 rows/sec for around 150k XML files. I am using PX 7.5.2. Other jobs are giving a good throughput. Is there any specific tuning for this xml stage that needs to b...

That means somewhere in your job you are converting from a fixed length CHAR field to a VarChar and are getting those ^Zs ... I checked all the stages, from source to target, i dont see any char..each and every stage its defined as varchar Also, if i USE a Load option instead or regular insert, i d...

ArndW wrote:That means somewhere in your job you are converting from a fixed length CHAR field to a VarChar and are getting those ^Zs ...

I checked all the stages, from source to target, i dont see any char..each and every stage its defined as varchar