To truncate table contents before loading data into it just follow the steps below:
- Go to workflow manager
- Create new session on mapping created before in designer
- Right click session and hit edit…
- Go to mapping tab
- Select a target from left column
- Under properties section check “truncate target table option”
Caution: This will truncate whole data present in target table!
Using: Informatica Power Center v 9.5.0