DSXchange

the table must have unique index on the key columns

i implememnted the same requirement, using oracle rank function and full outer join

need more information .
what is the load method? Append or upsert or ...............??
what is your source? file or table?

do you have a trnaformer stage in between the source and target?

Do you have the same issue if you run on a single node?

for upsert you must have unique index on the table, define that unique column(s) as key in the table metadata, and hash partition on that key

have you hash partitioned based on the unique index on the table?

What is commit size?
Do hash partition on the unique key column.

how many columns you have in the output metadata, and how many columns in the query?

check the position in both are mapped correctly

I think degree of parallelism for extracting is no. of nodes in ATP_CONFIG_FILE . the degree of parallelism for executing the query will depend on the Parallel hint option.

pad (||) in all columns except the last column

read the file use (,') as delimiter, and quote = none.
and then trim the single quote(').

Yes, you can do it in Datastage
create the first record with column name.

CLEAR.FILE RT_STATUSxxxxxx

for Teradata its in Datastage,.
In Teradata SQL you can create a table with name length 36, but not through Datastage in Teradata DB

so the problem solved, mark the topic resolved

Note:
you will get answer as per the question.
you didn't put your requirement correctly in first place?
you only ask about pivoting logic in datastage.