DSXchange

no Idea about DB2, But for teradata yes it is restricted to 32

what do you mean very low performance reading and writing the file??\
\how many records per second ?
how much you are expecting?

if you are deleting all records from table, then truncate and load in best option.
may be the requirement is not clear, why your lead is not accepting if the performance will improve.

are you getting white spaces too

then try

f isnull (AUDIT_IN_Agent_Activity.aac_share) or trim( (AUDIT_IN_Agent_Activity.aac_share)='' then 0 else DFloatToStringNoExp(AUDIT_IN_Agent_Activity.aac_share,8)

if EMP_SKILLS is last column then, you can do the pivoting in Shell script.

MS word has suggested word and auto correct option, can similar thing be implemented here, so that the typo error can be reduced.

very bad Ray. you don't have any idea.

Does Oracle Enterprise stage need a primary key on the Oracle table itself to perform an upsert properly? or just a unique index?? Or neither?

either

was the job run by same user everytime?

The one which work better for the condition.

have you checked the key checkbox?
can you use hash partition?

if possible, Partition the data and process in parallel

IF DRS_PS_D_PRJ.PROJECT_ID LIKE '8%' Then 'Y' Else 'N'
can be
IF LEFT(DRS_PS_D_PRJ.PROJECT_ID,1)='8' Then 'Y' Else 'N'

-----------

IF DRS_PS_D_PRJ.PROJECT_ID NOT LIKE '8%' Then 'Y' Else 'N'
can be
IF LEFT(DRS_PS_D_PRJ.PROJECT_ID,1)<>'8' Then 'Y' Else 'N'

its datastage warning, so you have to handle the null and conversion in datastage, rather then in the SQL.

whats there in "DDM_OWNER_TEST.MISSING_SCENARIOS"
specially at line 6