Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Source and Target Issue

Status
Not open for further replies.

sa0309

Programmer
Apr 5, 2010
45
US
I have a workflow that has 2 sources:

1. OraTable1
2. FlatFile

I run both sources thru a Union transformation then thru a Sorter transformation ( w/distinct ck'd to eliminate dups ). The output of my Sorter tranformation is input to my target table. Here's my issue, i want my Target to be a truncated version of OraTable1. In the session-task-mapping-target settings, I ck'd "truncate target table option". However; it appears the "truncate" takes place before OraTable1 is read as my source.

Basically i want to read OraTable1/FlatFile, transform, truncate OraTable1, then reload OraTable1. Is it possible to do this?

Any insight would be appreciated.

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top