How to implement this situation:have one source and one target,while load into the target first delete then insert?

Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.
but before I load into the target,I need to look-up some Dim ID,in this way,I must lookup twice.I think its not a good way.
It's there another better?

Interview Candidate
Oct 26th, 2006
2
2001

Informatica

Answer

Showing Answers 1 - 2 of 2 Answers

sats

Nov 1st, 2006

well...u can use the option Truncate target in session(target properties)
or use a truncate statement in pre-sql statement.
either of the two should work fine..

kishore

Nov 1st, 2006

use session option truncate table.if you use this option whenever you start the session it will delete the target table records and then load the new records.