DSXchange

The ORCH_WORK_XXXX table will not be dropped if the job abort.
similarly ORCH_ERR_XXXX will not be dropped if there are any error records.

using Teradata Enterprize stage,you can not delete record based on a condition in the input row.

for only Insert Teradata Enterprize stage is the fatstest.

then LOAD for update, insert and/or delete.

Yeah... but i am not sure wht to put as delimiter and other properties for csv file

you are saying its a CSV file that means it comma separated file.

you must be knowing what is the delimiter for your input file.
if it does not have any delimiter set it none

something like:

record
{final_delim=end, delim=',', quote=double}
(
Field001:string[max=200];
Field002:string[max=100];
)

Error loading "orchoracle": Could not load "orchoracle": No such file or directory.

probably you do not have the link for orchoracle in your library path
$DSHOME/../PXEngine/lib

enable dump_score for this job, and check what values are being passed.

Let me clarify:

The source stage metadata needs to be supplied at runtime as well.

that is what called, runtime column propogation

first you have to enable runtime column propogartion in datastage administrator. after that when you open the job in designer you will find a check box for runtime column propogation in the column tab on the oracle stage output tab.

F1 in the transformer stage, The help.

set the Sequential file as after dataset and dataset as before dataset link for Change Capture stage, and drop records for delete, update and insert, the output from this is what you need.

are you doing anything else in your job, then just reading the dataset and load using teradata Enterprise stage? it should not take more then 10 min to load this volume. the atrget is set table or multiset? have you choosen correct key and Primary Index. for lnsert Teradata Enterprise stage is faste...

how any sessions are used?

what is the scratch Dir? what is the size of it?

Search for "Capture duplicate" in this forum, you will find many suggested solutions.

is it because some UTF-8 character can be multibytes. means 1 character can be of 2 or more bytes