DSXchange

:? My mistake.. The table had some triggers created by Erwin.

Dropped them and there are no issues now.

Regards,
Bakul

Hi Shankar,
I have monitored the scratch disk usage when DS was processing the data at sort stage. I observed that row length * record count was exactly matching with disk usage.
Thanks,
-CDW

Hello All,

Is there any other way to achieve this without removing ceiling/size? This is especially important to retain the size when we want to use Metastage for metadata management.

Thanks,
-CDW

Thanks miwinter!!! Its now working as per expectations!

Hi, While using Oracle EE Stage, I am facing the following errors: 1) Column CUST_SKEY floating point decimal is not fully supported; adjusting the scale. 2) Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which ...

Hello All, We have many columns in our source tables where data type is varchar(500). However in actual practice many of these values are null and not more than 15 characters. My understanding was if we use sort then actual scratch disk space requirement would be (average row length * record count)....

Hi, I am using the Oracle EE stage to load data to a table. The default options of DIRECT and PARALLEL = TRUE are set. I have set Disable Constraints property to 'True' and have also included Index Option of Rebuild. The job aborts with the message: [quote]SQL*Loader 937: Parallel load requested and...

Hi, We are in the design phase for an application and have the basic job designs ready. The ADMIN team has requested for information on how much scratch space and resource disk space would we need for our project. What is the best way to estimate this and provide requisite estimates? We know the sta...

Hi, We are planning to use DSEE with oracle 10g. Source and target both will be in Oracle 10g. DSEE will be installed on the sever where source DB is installed. Target DB is on different LPAR. We are planning to use Oracle Enterprise Stage to get performance benifit. I am assuming that for DB, usual...