DSXchange

Your explanation does not make sense. You said i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE SO that means DSLINK6 is the reject link. But you say DSLINK4 DSLINK6.REJECTED 0 DSLINK6 DSLINK3.CITY='Berlin' checked 0 The link that is going to the DRS stage is used in the reject l...

Dont even think about killing the process using the dreaded 'kill' command. There can be open connections to a database, runaway processes that would leach over the resouces, not to mention, you getting a call from system admin. Try my method, set the warning level to 1, and if your timer times out,...

You never mentioned what error message are you getting.
Change DSLink6 constraint to.

You will also have to specify transaction size of 1 for this functionality to work properly. And there is a performance price to pay.
Uncheck the Reject box.

Look into the Basic.pdf. Its a Field Marker, system variable.

That is correct, no abort feature from command line. If your using a single Master control job then instead of Execute Command Activity, you can use a Routine Activity and call UtilityAbortToLog(). That will force abort the job. Or if your warning level is set to 1, then you can do something like ds...

Yes. Read the statement. If (after trimming there is nothing) then SetNull else (trim the incoming value of spaces and output the value). Better yet, test it.

Dont give any space between the two double quotes or it will always look for a single space which trim is getting rid off and it will never SetNull.

As you said, the trigger fires for insert/update/delete, so for every row going into the table, the trigger will fire. Thats what it does. If you need to do it only for the first row, you need to program it inside the trigger. Make it a statement level trigger. Check out . here. or here . Google for...

Not sure about that. Never played with the repository a lot. Maybe someone else can throw some more light on it. But why do you want to do that? Its considered a hack and not supported.

You definately can.
SORT input.txt will sort on the first column
SORT /+2 input.txt will sort on second column. And so on. Refer herefor more details.

Thats odd. The jobstatus is leveraged upto the jobactivity trigger which then routes it accordingly. Need more info on your job design and warnings that you are getting.

If you use agregator, you have also 6 stages : SeqFile - Sort Stage - Agregator - HFile - Transformer - File1 + File2(Doublon) Its best to use a sort stage before aggregator. Else the performance is going to suffer, it might even run out of temp space if the data volume is huge. That brings it up t...

In both the methods you need data to be sorted on the key. But in method advised by me and akarmarker, everything is done in just the transformer, where as in your solution advised, you need to aggregate it, use hashed file and then the transformer. Two extra stages. See the difference. For small am...

DSLink6.F1 = (DSLink3.F1 + 5)

This line suggests that you are adding 5 to column F1 and assigning it to the output F1. What is the sql type of F1 ?

YOu need an odbc driver to connect to the xls sheet. or you need to convert it into csv format and then read it with Sequential File stage.