DSXchange

May be


We can have link collector with 3 input links for the sequential files with same meta data.... then sort stage on AcctID.... then aggregator stage with group by on AcctID and "first" function on other fields...

Thanks

May be its because in original project you have
WORKDIR
SCRIPTDIR with default values set...

and in current project nothing set for the variables.

Please check in job properties and environment variables...

As per what I understood... suppose A, B are the key columns C, D, E are to be updated and F, G, H not to be updated then pass F, G, H as NULL values... and use only one statement like update TABLE SET C = NVL(:3, C), D = NVL(:4, D), E = NVL(:5, E), F = NVL(:6, F), G = NVL(:7, G), H = NVL(:8, H) WHE...

According to me... Option 1. store the timestamp of run in a hashfile. pull all the data from source. filter with hash value and propagate only new records. Option 2. Store timestamp in hashfile create routine to read the hashfile and output the value. call this routine in Routine Activity. Pass the...

Hi,

According to me.... the name should be unique for calling the job. So usually <Parent Job>.<Child Job> should be the name format.

Select the stages which are suitable for parallel run and requirement