DSXchange

n00b here too @INROWNUM looks like the trick, but perhaps you could pair it with @OUTROWNUM I'd build a job like this.. In transformer, add a constraint. The constraint would be something like: @INROWNUM > 1 and @INROWNUM <> @OUTROWNUM If the constraint evaluates to true, the output link should have...

ray.wurlod wrote:Please check the following.

FTP stage

ORABULK stage

both are passive

You can use the Update action of 'Truncate table then insert' to create a job that just does the truncate for you. It can then be included in your jobstream (via a Sequencer job, for instance) just before your bulk load job... We ended up using the 'Manual Mode' of the bulk load stage to do this. T...

From my reading of the forums, use of the Oracle OCI Load is the preferred method for fast performance. I'm looking to use this method to load several "large" staging tables. My staging tables, however, are temporary from month to month. I'd like to clear the data before the load. Looking ...