DML statements in "Pre SQL".

[ProDev]

Hi,

In fact, I am trying something like this.

DELETE the target table before new
records are inserted through my Work Flow.

I tried "Pre SQL" option. It did help me.

There are 2 places available where we can have "Pre SQL" option set.

One is inside mapping at target instance Properties.
Other is at the session level 'Transformation' Pre SQL.

So which is the best one to use and what is the difference ?

Also, is this DML statment gets fired only once, when session is run
OR
runs for all the rows those pass through ?


Thanks

 

[raj4Informatica]

Prodev,

If u want to delete all the records before loading, use truncate option od session properties instead of writing the Pre/post SQL.

HTH

Rajesh