DSXchange

Did you see any warnings in the director. Did you clear the propagate partition in previous stages?

Ans is where the routine return values are stored. You can store the status of the routine or pass any value to job. It must be assigned with value.

In which DB you are trying to acheive this. or you are trying to acheive in Datastage

What harm it will cause if we write a manual insert statement in the DB stage? that is insert statement with nextval for sequence. I havent tried it.

Do the colon part of content should be acting as delimiter or data?

Can you post the parameters and env variable that was logged in director for the run that showed this error.

If the framework is able to insert a record in to audit table, it must be able to select a record from audit table. So you can make the selection in framework and since the framework is doing the scheduling you can pass the extracted run date as paramter to the script that invokes the job. In case b...

From where you are getting this excel file. You can better ask the source window team to save their excel in CSV and then put in Unix Box. In case if you go with ODBC driver, you may be in a place to face issue. Like the empty cell in excel at last may throw issue. Zip code/ columns with zero left p...

Did you edit the automatically generated script?

In teradata, is it going to be bulk load?
Why not achieve this simple transformation in the SQL query?
In this case , like one schema file for each file, you must have a sql query for each table and it must be maintained somewhere.
Not sure of the feasibility. Just a thought

If it is a incremental load then the drop delete records should be set to zero.

because i need to extract delete records also

Which records you are mentioning about.
And you can have delete records seperated withhelp of a filter stage using the changeCode column in output link

to resolve the problem you are compromising the performance. is it fine?

are you getting the same warning again?

When writing column VARCHAR(min=0,max=n) into database column CHAR(min=n,max=n), truncation, loss of precision or data corruption can occur.

In the schema file if you have defined the datatype as char(n) then the APT_STRING_PADCHAR would have got appended.
Or in transformer right pad the column with spaces

Basically what i think is file name in the output link can be used only when the data needs to be processed based on the file name, you dont have such requirement, Go with commands