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
  • 2
  • 1920

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..

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions