https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53196#M528 If you are looking for a single transformation that truncates many tables, there is none.<BR /> I suggest that you crate a User Written Transformation to do this, which is quite simple (I have done one for SPD Server once). Use macro lopping over the input tables to the transformation which you would like to truncate<BR /> <BR /> /Linus Wed, 20 Apr 2011 08:08:03 GMT LinusH 2011-04-20T08:08:03Z https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53195#M527 I need to find a method to truncate bunch of tables in Oracle. Is there a transformation available to do that?<BR /> <BR /> Thanks,<BR /> <BR /> MI Tue, 19 Apr 2011 13:48:48 GMT https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53195#M527 Halaku 2011-04-19T13:48:48Z https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53196#M528 If you are looking for a single transformation that truncates many tables, there is none.<BR /> I suggest that you crate a User Written Transformation to do this, which is quite simple (I have done one for SPD Server once). Use macro lopping over the input tables to the transformation which you would like to truncate<BR /> <BR /> /Linus Wed, 20 Apr 2011 08:08:03 GMT https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53196#M528 LinusH 2011-04-20T08:08:03Z https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53197#M529 Hi Linus<BR /> Agree with Oracle. With SPDS the table loader in DIS4.2 actually allows truncation so one could also implement this using a loop. Sun, 24 Apr 2011 06:36:27 GMT https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53197#M529 Patrick 2011-04-24T06:36:27Z https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53198#M530 The general table loader also supports the truncate behavior in 4.2 for most databases. You can also try that approach, and the Loop idea is a good suggestion to manage this for multiple tables. Mon, 25 Apr 2011 19:36:08 GMT https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53198#M530 nar_sas 2011-04-25T19:36:08Z https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53199#M531 Thanks folks for the reply. Fri, 13 May 2011 14:07:00 GMT https://communities.sas.com/t5/SAS-Data-Management/How-do-I-truncate-a-table-using-transformation/m-p/53199#M531 Halaku 2011-05-13T14:07:00Z