Hi,
I have one table with 50 fields if any of the column is changed, then add a new row with updated record.
Hi mate,
I'm not sure what you mean exactly, but here is my guess: you want to control or prevent the table changes.
For this check out - About CDC Control Tables or Creating a Control Table
Moved to the home forum for DI Studio questions.
If this is a target table I would recommend the SCD Type 2 Loader.
How to use depends on the other requirements that you have, design decisions and your data model,
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.