DSXchange

There are no before SQL statements that are executed in the source Teradata stages.

Hi, There is a datastage job with Teradata Enterprise stage and Teradata API stages as the source. Data is being loaded to Oracle. All the stages in this job are running in sequential mode. The start up time of this job is low most of the times. Sometimes the start up time is very high(approx 15 min...

The requirement is: Using orchadmin command, copy the data from one dataset to a new dataset and the data files for the new dataset should be created. I executed orchadmin copy command: orchadmin copy | cp sourcedataset targetdataset I see that the descriptor file for target dataset is created. Howe...

Hi, We have a job with Oracle Enterprise stage as the target. The job has 1.3 million+ records coming from source. This job has been migrated from DatStage7.5.1 The design is as below: ODBC--->Transformer-->Remove Duplicates-->Oracle Enterprise | | Sequential file In DataStage 7.5.1, the job finishe...

Hi, I have parallel job where data is coming from DRS stage(67 rows), then lookup is performed with ODBC stage(reference data, 1.5 million rows) which is then loaded into tdmload stage. The job aborts with the error:Fatal Error: Fatal: MultiLoad returned: 8 ** Please refer to statements in /data/pro...