DSXchange

Looks like this can come from a client / database version mismatch: http://www.orafaq.com/maillist/oracle-l/2007/10/17/0386.htm ... Criag, Thanks for the link.... I changed the Direct Load from TRUE to FALSE and the job ran successfully.... $APT_ORACLE_LOAD_OPTIONS = OPTIONS (DIRECT=FALSE, PARALLEL...

Hi, I am trying to migrate a datastage job from Datastage 7.5 to 8 which loads a dataset in to an oracle table using SQL Loader. I am using ORA OCi Write Method = Load Write Mode = Append This job runs absolutely fine in 7.5 but in version 8 i am getting the following error SQL*Loader-925: Error whi...

Craig,

I think i misinterpreted CASE SENSITIVE option in the Manual.
So you mean to say this about column data not column name(Key) right?

Thanks for your help....
AM

chulett wrote:I would assume they mean the case of the key column data, not of the column names. ...

Craig,

It is column names not the column data.

Thanks
AM

Hi, I wrote a parallel job which extracts data from different tables in oracle and writes them in to different datasets. In the next job i am merging all these datasets with the master dataset and the key is acct_id in all the datasets, but i have one dataset whose key is ACCT_ID in upper case. When...

chulett wrote:Maybe... big maybe. If your target table partitioned? ...

yes its a partitioned table

I dont think you will save any time by converting the sqlldr to OCI stage. Because the time spent in moving the data to Flat file to Dataset must also taken in to count. so some the options are 1. Increase your parallelism to 4 then you can see some change. We dont your server config . so try by in...

Hi, I am writing a new parallel job for loading an oracle which was already written in server before. In server job it uses Sql Loader to load 300 million flat file in to a oracle table. My first question is which one is the best approach to load, either to directly use sequential file to load the t...

Hi Friends I have a weird problem when i am trying to import a copy book in to the CFF Stage, i am getting an error like " DSDesign.exe has generated errors and it will be closed by the windows. You will need to restart the program " I have no clue what to do :( The copy book has 7000 fiel...

DSguru2B wrote:What are you doing in your transformer?
Are you calling some kind of routines ?

No i am not calling any routines, i am just doing some lookups.
In the source that is oracle i am doing a join between 3 tables and loading it to a Flat File.

Does the job do any other writing to files? If I understood you correctly, your job aborted but some prt of it was still running for 12 hours after the abort message? I ran this job when i was going home yesterday. When i looked at the log today in the morning, it got aborted after one hour and i d...

Hi Guys I have a weird problem with one of my jobs. My job got aborted due to lack of tempspace and i have the message in the log. But after 12 hours it loaded the records in to the sequential file :o . Did you guys faced anything like this before, if so can please you explain me about this. Thank You

Hi Guys You totally misunderstood me. I will try to rephrase the whole thing. I have an Oracle table with 36 columns.(like code1, code2, code3,.....,code36) So each record might have 36 codes. But there is an exception here , if 001 is found in any of the codes the remaining codes are NULLS. So my r...

the ouput should be only 3

Hi Guys... I am working on a job which requires me to output the max sequence number from a record based on a particular condition. In my table i have columns which are code1, code2, code3,.......code36. When ever there is '001' in the one of the codes i have to output the number associated with the...