DSXchange

Use Write mode Delete then Insert

Does Upsert mode have a Delete before Insert option?

You might investigate the Distributed Transaction stage, but I suspect that rollback won't be possible. Reversal may, of course, be designed in if every record is identified with the job run that inserted/updated it. Reversing deletions requires capture of a before-image.

Nice.

You may need to expand the Advanced Find result window horizontallly (or scroll right) to get to the modifier and dtm information.

OK, please mark this thread as Resolved.

1.Minimize the usage of Transformer(instead of use copy,modify,filter,row generator) 2.Reduce the number of lookups in job design use not more than 20 stages in a job 3.There is no limit for no of stages like 20 or 30 but we can break the job into small jobs then we use dataset stages to store data...

But, being on the other side of the planet, I tend to be asleep when you're awake. As far as the linked post is concerned, the ps command there is explicitly grepping (is that a word?) for the section leader flag, so that the processes visible are all section leaders. Perhaps grep -v APT_PMsectionLe...

When you have the Discard Value property selected the Information panel explains what it is doing. Type: Integer Specifies an integer value of the selector column, or the value to which it was mapped using Case, that causes a row to be discarded (not rejected). Note that if it was mapped then the ma...

i can not use Server Jobs in my project. Why not? And in any case, these functions are available in the BASIC Transformer stage (available in parallel jobs), or you could package some server job components into a server Shared Container and use that in a parallel job. On those bases it was reasonab...

I would assume that the statement "trying to make use of looping" suggests very strongly that version 8.5 or higher is involved. @ITERATION will only appear in the derivation of the Loop condition itself or loop variables. It is not available for output link constraints or in any other kin...

You run the data through a Match Frequencies stage.

Two fundamentals.

1. A test plan is created and approved based on the original specifications (often available from FastTrack). The test report must cover every point in the test plan, reporting expected, actual, pass/fail and comments.

2. The test is never performed by the job's creator.

The approach I'd take would be to report all the link objects from the DS_JOBOBJECTS table, limiting OLETYTPE to just those that indicate that the link is an input link or an output link (for example WHERE OLETYPE LIKE '%put%'). This query could be executed from the Administrator client Command wind...

Well, yes and no. Advanced Find allows a slightly different question to be answered; which jobs were last modified by user X. I don't think this is what dipanjan was seeking. As far as I am aware there is no way in any of the clients to determine who created or who last modified a job. This informat...

We follow a similar peer review mechanism, though it's before the artefacts leave the DEV environment at all - that is, before they go into SIT or UAT. No changes are permitted other than in DEV, which guarantees that when artefacts are deployed into production they are compliant. And testing in SIT...