DSXchange

Ray,

I already have the partition table option set to the biggest table from the set of 5 tables being joined in this query.

Only difference is TOAD returns the first 100 records whereas in DS it will have to process all the records before any stats is shown That was part of my question Yes, whether DS would wait to read those 30 mil before starting to move on to next stage which i did not expect. Also, when i run from T...

Yes Craig, the explain plan is the same. I just restarted the DS job and checked to confirm that. is it possible that it is going to wait until it reads the entire 30 mil before moving on to next stage? Because when watching the session (from TOAD) when job runs from DS, i see the number of rows pro...

Default execution mode is Sequential mode (option is grayed out) in Stage->Advanced->Excecution mode for the ORA stage

Hi, I have a job design like this ORA->LKP->XFR->ORA The first ORA stage executes a source query running a join between a few huge tables. This query results in close to 30 million records. To tune this query to return records faster, we added some Oracle hints. The query with oracle hints starts pu...

ArndW, I did as you suggested and set one of the columns (colB) to not-nullable and ran the test jobs and nothing was captured in the rejects and the column (colB) was populated correctly for all records. however i still have inconsistent data for the other columns which are still nllable columns (c...

Unfortunately, adding that environment variable didnt help. the first two test runs still had the same behaviour

Thanks

Yes, the job has only two stages ORA -> ORA

I will surely try with that environment variable. since this kind of behaviour happens randomly to random records, i will do a couple runs to check if this works.

thanks

Hi, I have a strange problem going on with a job design. Job has 2 ORA stages. Source ORA stage is executing a SELECT on source table and pulling some data for a couple of columns. Target ORA stage is executing an Upsert - If seq_no (key column) exists then execute an Update else execute an Insert. ...