Date: Fri, 6 Aug 2010 07:02:57 -0400
Reply-To: Dave Brewer <david.brewer@UC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dave Brewer <david.brewer@UC.EDU>
Subject: Re: PASSTHRU SQL Question
What is DI Studio?
On Thu, 5 Aug 2010 10:59:50 -0400, Suzanne McCoy
>If you did this in DI Studio it would probably code a data set with
>update, insert and modify logic instead of a proc append. It pretty much
>does this as the default for slowly changing dimensions but it can be
>applied any time as long as you can use or build a unique key for record
>I personally tend to do multiple steps just so I can see exactly what is
>happening. I'd bust the data into staging tables like keep_no_changes,
>insert_because_new, terminate_old_insert_new by using merge logic with in=
>operators to compare the new data to the existing data by relational keys.