DSXchange

Well you need to build the user defined routine as a before/after job subroutine instead of a transform routine. Thats the first thing. Then it should show up in the drop down list of before/after job subroutines.

Always, for server jobs. For px jobs, if any transformation is required with rcp turned on, then yes, else no.

Technically speaking, if the 1-5 records are the duplicates, then it doesnt matter if you compare the 1st record to the 5th or the 4th to the 5th. Thats why you need to sort the data on the key your which requires de-duping.

About the APT_COMPILER and APT_LINKER values, make sure that the path for the compiler is correct. Your admin should be able to verify that for you.
Currently you just have g++. You need the fully qualified path.

RCP is not present in server jobs.

Nulls as keys is not a good idea in a hashed file. Massage the file prehand to replace nulls to some other value.

You should be fine. Because I dont think the basic transformer really cares. Are you getting the right data without any warnings?
If the answer is yes then you can mark this as a workaround as it really is'nt a solution.

You dont need to go the "environment variable" route for this. Write your value to a file. Write a small routine that reads the contents of the file using DSExecute() by doing a cat. Call that routine in the job activity in the derivation of "a" job parameter. This way whatever is present in the fil...

Send a few records to peek stage. FMT() function should work. Did you use it exactly as I asked you to use it?

Where are you loading the data?

Do a join on all the columns. Or someone has to identify keys for you to capture change.

What if you change the BIGINT to integer within Oracle Enterprise stage. Does that fix your problem?

No between function. You can use logical operators to do that.

If your using basic transformer to do that then you can use the following

Go with point 1. How will you go about getting that done? Well that depends upon how you will be controlling the process. Is it via job sequence or via a shell script?