Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to Truncate a table after the mapping is executed?

552509Jan 19 2007 — edited Jan 25 2007

Hi
My cases cenarion is like this.
I have a table TEMP_TAB, which im using as a temporary table and to update the Target table. Once the target table is updated, i want to truncate TEMP_TAB table.

I have tried using the Post Mapping Operator but it is expecting some inputs. but i dont know what input i should give.

can some one help with how to use the post mappinng operator?

Regards
Vibhuti

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2007

Added on Jan 19 2007

#data-warehousing, #warehouse-builder

15 comments

992 views