DSXchange

Chullet correct it's oracle date (or timestamp).

So to deduce from you comments.

The Stage Variable has no default value set so what is the outcome ?

Thanks Chullet, it seem to be keeping the storage so off to the DBA's I go !!

Hi,

I am using a oes Oracle Enterprise job to insert data into a table with the truncate option.

Does anyone know if this use the reuse staorage option or the delete storage option ???

Thanks,
Jeremy

Hi, Could someone help me with some logic please.. I have this piece in a transformer and am wondering what it is trying to do really If @INROWNUM = 1 Then CurrentTimestamp () Else svCREATIONDATE svCREATIONDATE is a varchar and then it is put into a date field. Surely they would have been better off...

Chulett

3.9 million rows load using Oracle Enterprise stage 5 mins.

loaded with bulk loader / maual mode 29 mins ???

Chulett,

Thanks for the advice, I have changed it to manual so now it creates the dat , ctl files and it still runs really slowly compared with just loading it using a Oracle Enterprise stage.

I was under the understanding that the OCI Bulk load would speed things up considerably ?

Oracle OCIBulk slowed down insert as opposed to standard ora stage? I have tried to speed up inserts into a DB from a dataset using OCIBulk load. However this has slowed the insert down by 800% !!! I have an autmoatic load and the DB is on another server. Does anyone have any ideas why this should h...

Ray, that's correct they are produced by oracle however, when initiating a SQLLoader from the command line with out using DS the files are defintaley legible.

There is no special tool to read the bad files I have come across in my 10 years in Oracle development.

ANy other ideas guys ?

Hi,

I am having problems reading the .bad files created by the Oracle ENterprise stage loading data into ORalce.

I can read the .log files fine however I cannot read the .bad files they are complete incoherent jargon.

All help greatly received.

Hi,

Thanks for the reply how would I do that in the transformer/ modify stage please can you sow me the code perhaps.

I am very new to this game !!!

Hi, I have a integer(4) comming into a transformer stage which I want to convert to a varchar. I cannot use a inttostring because there is no function (or is there ?). I therfore use DecimalToString to convert to a varchar(64) however it has leading and trailing zeros i.e. 7869 comes out as 00000000...

Hi, I have two large DS extracted from Oracle tables which are joined on ACCT and TNT, and then filtered on dates. Before I was getting problems with the join as the data was not sorted into DS correctly I have hash partitioned both datasets on the above keys and now when I join them and then filter...

Thanks, how do I pass the parameter do I define it in the job that requires it and then pass it within the sequence ?

Hi I am at a brick wall at the moment. I have the following SQL ... SELECT LAST_PROCESS_DATE FROM RSB_PROCESS_DATES WHERE IDENTIFIER = 'CURRENT_WEEK_END_DATE' SELECT * FROM CIS_IMPORT_TS032_BILL_CHRG BCHG where ( BCHG.D_CHRG_CNC >= TRUNC(ADD_MONTHS('parameter', -3)) OR BCHG.D_BC_POST >= TRUNC(ADD_MO...

Hi,

I know I have read all there is but I still can't manage to set the DSSetJobLimit to a different value as I dont know where to set it in the job sequence can anyone please help me as I am near breaking point.

Many tanks
Jeremy