DSXchange

how will 101 fit in decimal(7,5)? decimal (7,5) can be 99.99999

if you want to do in datastage then , in a transformer stage do a mapping like

'echo ':INPUT_COLUMN:' >> ':INPUT_COLUMN:'.txt'

and the in after job subroutine, just execute the target file.

that means if for example , the FLAG value is 3 then update column C, if 4 then D, if 5 then E etc.

Then this query should work:

update TABLE
SET C = DECODE(FLAG,3,:3, C),
D = DECODE(FLAG,4,:4, D),
E = DECODE(FLAG,5,:5, E),
F = DECODE(FLAG,6,:6, F)
WHERE A= :1 AND B = :2

My requirment is first record should be inserted with an additional column FLAG= 'I'. If we get another record with the same key it should be updated with the column FLAG = 'U'. If the record with EMPNO=7368 is already there in table, it should also be updated?? so it can be : Desired target EMPNO ...

why do you need to lookup the same table, which is being insert/update??
why can't directly use UPSERT.

check in the oracle for any table locks, wait etc... check if your SQL is waiting for any lock to be released

you can use aggregator stage, to select max of each non key column..


Ques: what will you do if the data is like this:
Key1,Col1,Col2,Col3
1,A,Null,Null
1,D,Null,Null
1,Null,Null,B
1,Null,B,Null
1,D,Null,Null

you can use an after job subroutine, to delete the file if it is empty

if the the metadata for output are same then it can be done in one query using union

remove the node from NODE_TABLE

Read as a single column and in a transformer use the FIELD function to split

If that is the case why we have even option out there?

check with IBM.

the same stage(MLOAD) is used for TPUMP also which can run in parallel.

Teradata Enterprise stage is meant for running in parallel, it uses Fastload/fastexport

because you can not run more then one MLOAD on a table at a time..
making it parallel means more then one MLOAD will trigger on the target table.

did you try search?, its very common problem

viewtopic.php?t=109330

what is the data format? FASTLOAD or VARTEXT?