https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66979#M19158 Hi,<BR /> <BR /> I'm not sure if there's actually a way to do that. However if you would like to track changes in your dataset you might opt to use the SCD Type 2 Loader transformation. Hope this helps<BR /> <BR /> Regards,<BR /> milton Wed, 26 Aug 2009 04:35:06 GMT milts 2009-08-26T04:35:06Z https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66978#M19157 Hi,<BR /> <BR /> I have a question regarding the using of the SAS Data Integration Studio.<BR /> <BR /> The scenario is like this: <BR /> If i have 1 million records previous in this dataset, then i do a update on 1 record and insert another record to the dataset.<BR /> <BR /> Am I able to reflect the changes ( 1 updated record and 1 inserted record ) in the dataset. As in only show these 2 records only. Is it possible?<BR /> <BR /> Thanks.<BR /> <BR /> Yours Sincerely,<BR /> helphelp Wed, 26 Aug 2009 03:05:18 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66978#M19157 deleted_user 2009-08-26T03:05:18Z https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66979#M19158 Hi,<BR /> <BR /> I'm not sure if there's actually a way to do that. However if you would like to track changes in your dataset you might opt to use the SCD Type 2 Loader transformation. Hope this helps<BR /> <BR /> Regards,<BR /> milton Wed, 26 Aug 2009 04:35:06 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66979#M19158 milts 2009-08-26T04:35:06Z https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66980#M19159 have you looked at SAS audit trails? Wed, 26 Aug 2009 13:13:05 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-show-new-updated-records-in-the-target-table/m-p/66980#M19159 Peter_C 2009-08-26T13:13:05Z