| |
GeekInterview.com > Tech FAQs > Informatica
| Print | |
Question: How to implement this situation:have one source and one target,while load into the target first delete then insert?
Answer: 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? |
| November 11, 2006 08:05:53 |
#2 |
| kishore |
Member Since: Visitor Total Comments: N/A |
RE: How to implement this situation:have one source an...
|
| 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. |
| |
Back To Question | |
