DSXchange

Hi Friends, I have observed a difference in DS 7.5 and DS8.1 server edition. When I double click on a finished job in director in DS 7.5 there we can see the password in encrypted format. But at the same time when I double click on a finished job in director in DS8.1 server edition I can the see pas...

Hi Friends, I am loading the target (oracle) from a flat file using ORACLE OCI BULK but before loading I want truncate the target table. But there is no option to delete or truncate the table before loading in ORACLE OCI BULK stage. Can anyone help me with alternate way without creating one more job...

ray.wurlod wrote:Decrease transaction size (rows per transaction) to, say, 50. If the UNDO tablespace is OK after that, try increasing by a factor of 2 until the problem recurs, then back off till it disappears again ...

Thanks Ray , It worked at 100 transaction size

Sainath.Srinivasan wrote:What is your commit size ?

Array size 50
Transaction Size 1000
rows per transaction 1000

Please let me know If i have change or increase anything

Then they didn't increase it enough. :? How big is your flat file? What kind of "load" are you doing? ... Flat file size is around 4678712 bytes, Im just loading into target(straight Load) with a transformer stage in between flat file and target(oracle OCI stage version 2) written a custo...

Talk to your DBA. They may need to increase that tablespace or you may need to commit more often. Or perhaps just wait and try again. ... Thanks Chulett, I have even asked my DBA to increase the table space but that didnt work work out still getting the same error . And I have tried running it lot ...

Hi Friends,

Im loading flat file to Target table oracle, I am getting this error can anyone help me please.


ORA-30036: unable to extend segment by 4 in undo tablespace 'UNDO1'

and the job gets aborted.

Hi Friends, Im trying to send a mail with attached of .csv format using Notification activity but when I run the job it fails with the below error can anyone help me please. *** Output from command was: *** /home/odsdev/dead.letter... Saved message in /home/odsdev/dead.letter The following parameter...

karry450 wrote:And also can you please help me if I want get only the alphabets out of the string

THANKS Ray I hat got the output
for alphabets I used LETTERS

And also can you please help me if I want get only the alphabets out of the string

ray.wurlod wrote:Use the DIGITS Transform. This is precisely what it does. ...

Hi Ray Can please elobarate on this.

Hi Friends,


My input data is VARCHAR 255 ( ASFG1J3K88U7) and I want to extract only the numeric numbers from above input as ( 13887) as output of it to target table .

Can anyone help me on this.

Hi friends


I want to read a TABLE NAME from log of a job and use the same for the input of a next job

can anyone help me please

Hi friends,

I want to call a procudere through an ORACLE OCI stage after reading some value of column in one table can anyone help me on this approach.


Thanks

chulett wrote:Have you tried searching for "Fault type is 11. Layer type is BASIC run machine." yet? It turns up several matches. It may also help to fully describe your job. ...

But none of the posts helped me