DSXchange

Add an extra output link, send your stage variables to it, and see whether your Field() functions are working as you anticipated.

Up to 1GB to 2GB is still medium, depending on the hardware.

1) ho hum
2) not true - you can use hash table method or allow tsort operators to be inserted
3) doesn't everything?
4) my glass is half full - no, wait a minute, that's not my glass, my glass had MORE in it than that

What you read is true of server jobs.

Parallel jobs are far more sensitive to the compiler and operating system versions.

What a very short-sighted requirement! You free up the space taken by the logs, use it for something else, then there's no space left to log anything. Tell "them" to go buy some more disk. Certainly purging your logs is good practice, but this does not automatically give back the disk space. Resist!...

swapnilverma wrote:I expect help from all forum members....

That would imply more than 22,000 answers to each of your questions.
Is that really what you expect?
Would you promise to read each and every single one of them?

There are more kinds of metadata than "technical metadata".

What partitioning is specified on the input (a) of the Sort stage and (b) of the Remove Duplicates stage? Are there any stages between these two?

What are your specified Sort keys? What are your specified Remove Duplicate keys?

A schema file is a standard Orchestrate record schema that accurately describes the format of your data, but the record schema is stored in a separate file rather than as properties of your Sequential File stage. You can create them simply by saving existing table definitions as record schema files.

The same job you are trying to run?

Put some DSLogInfo() calls into the routine to show when you are entering and exiting the routine, so that you can eliminate the routine (or not) as the culprit.

Job Sequences themselves do not have any innate parallelism, and BASIC expressions (and therefore routines) can be used throughout. Well-designed server jobs can process small to medium volumes of data faster than parallel jobs, particularly if the latter have not been well-designed, but also becaus...

It's up to you to make sure that that happens, when you are constructing the Shared Container. When it comes time to use the Shared Container, you also need to validate that the links correspond and that the link names can be mapped if they are not identical inside and outside the container. Shared ...

Please post the full warning. We need to know where it is being generated. If it is being generated in the Transformer stage (no Teradata stamps in the message) then the derivation is awry (which I doubt). Break up the expression into two stage variables, one with the Iconv() and one with the Oconv(...

No, only IBM, and that in exchange for money or the promise of money.

What format does Teradata require?
Your Iconv() function is good.
Your Oconv() function is good only if Teradata requires YYYY-MM-DD format.
What error message is logged?