DSXchange

An improvement in performance was seen when the following was done 1. I used Oracle OCI Loader stage instead of the enterprise stage. 2. DBA has increased the undo table space and redo logs. There was a question raised from all these experimentation. tnsnames was changed to point to node2. However, ...

Hi, when I run the job from a Shell script, in case of some Multi Instance jobs, I get error messages in Unix like Error -4 getting details for event 1 Error -4 getting details for event 2 ....... Error -4 getting details for event 22 Error -4 getting details for event 23 when trying to write the de...

Thanks chulett,
It worked fine now.

It worked..it seems the DBA priveleges started working now!!

How will the job work if I remove the Trigger file..The Transformer always needs a Primary input..right?
I tried and it did not compile w/o the Seq file..

Hi, Job design, Trigger File ----> Transformer ---> Oracle OCI I am using a Multi Instance job (Table name as Instance Id) with Update action "Truncate Table and then Insert rows" to truncate the data and insert NO rows,ensuring this thru the transformer constraint 1=2. But it fails saying...

Hi All, I load around 2 million records into an ORACLE table using a job that runs on two nodes. It takes around 30 minutes for Inserts and 30 for Updates {little longer for updates}. I was hoping to try bring the time down. The Insert / Update jobs are very straingt forward. Its just Datasets loadi...

Thanks. It works

Is any thing I can do in ETL to improve the performance.

Thanks
Suresh

Hi,

How can we convert the following string

07/09/2007 07:41:01 PM ----> 2007-07-09 19:41:01 (Timestamp)

Basically need to convert string having either "AM" or "PM" to standard Oracle Timestamp format YYYY-MM-DD HH24:MM:SS

Thanks,
NV

Resolved..I got it...
A silly Mistake..Incorrect Table Name Used!!

SeqFile ("|" delimited .txt file) --> Transformer (Null Handling) --> Oracle OCI9 (Inserts)

Hi All, I am trying to load a TXT file data having some 87000 recs (file size - 22 MB) to an Oracle table with very minimal transformation. On running the Server job, it throws the following message and job aborts DataStage Job 233 Phantom 18132 Program "*DataStage*DSR_LOADSTRING": Line 14...

Hi, one of the job I have created loads the data into a table; source is dataset and target is oracle stage. only two stages in the job. In oracle stage I defined Index Mode = Rebuild write method = load Write Mode = truncate In job properties I defined the load option : $APT_ORACLE_LOAD_OPTIONS=OPT...

Kris,

I am already getting it in Oracle and I have posted the SQL here!
My query was how to achieve it in Datastage?

Hi, I have a req where I need to jon 3 tables but there is no common key for all tables. Trying to achive this in 2 seperate stages but not returnig the required result due to 1:many relationship between a & b,b & c tables. Can this be done using 1 Join stage or how else can this be done in ...