Oracle Database Connection
Posted: Wed Oct 07, 2009 8:11 am
Hello All,
I have an extract job, which reads the data from an Oracle job. This job has some extensive transformation logic in it. Does this job retains the connection to Oracle even after the extract stage is completely done? The problem is... we are getting the "Snapshot is too old" error message from Oracle, even though we have completed reading the data from Oracle and it is performing some other stages in the job.
Along the same lines, does it make the connection and reserve the number of sessions requested to Teradata at the start of load job before even it gets to the Teradata Mload stage?
Please asssist.
I have an extract job, which reads the data from an Oracle job. This job has some extensive transformation logic in it. Does this job retains the connection to Oracle even after the extract stage is completely done? The problem is... we are getting the "Snapshot is too old" error message from Oracle, even though we have completed reading the data from Oracle and it is performing some other stages in the job.
Along the same lines, does it make the connection and reserve the number of sessions requested to Teradata at the start of load job before even it gets to the Teradata Mload stage?
Please asssist.