How to show new/updated records in the target table?

[deleted_user]

Hi,

I have a question regarding the using of the SAS Data Integration Studio.

The scenario is like this:
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.

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?

Thanks.

Yours Sincerely,
helphelp

[milts]

Hi,

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

Regards,
milton

[Peter_C]

have you looked at SAS audit trails?