DSXchange

I think we are using row buffering.

RC

Hi Here are the error messages I am getting . These are with Previous run title. Project:smqa (whseqa) Job name:LdTouchpointFactDICatalogs Event #:127 Timestamp:2/1/2005 10:41:10 AM Event type:Info User:qdssmqa Message: From previous run DataStage Job 237 Phantom 18248 jobnotify: Unknown error DataS...

Hi, You are right, We have standard way of using DS. We split the jobs in to SRC, Look Up, XClean,Xmap,Xkey,Load. In my case, I skipped Xkey. I extracted data from Oracle using OCI---Transformer---Seq file and then did cleansing,Xmap and then started doing Load, using SEQ------Transformer-----OCI. I...

Hi, Thanks for the reply. I do get the "Resetting Previous Job ..." message in the log.In the I do see a message saying "BASIC" error, DSD.SEQClose error. I can send you an exact error message tomorrow.

Please let me know.

Thanks again
RC

Thanks. I am using Oracle9i Stage for loading the data from already created sequential file in to an oracle table using the Insert or update clause we have on Oracle9i stage. When I load data for less records everything is fine. The issue is when I load more records. I don't see any errors in the lo...

Hi All, I am new to DS. I have created a new job in DS 6 which selects the data from an Oracle table(The select statement has UNION ALL) and then writes to a sequential file and then goes through mapping process before I insert the same data in to an Oracle table on the different database. The targe...