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
Comments: To: Suzanne McCoy <suzanne.mccoy@CATALINAMARKETING.COM>

Suzanne,

What is DI Studio?

Dave

On Thu, 5 Aug 2010 10:59:50 -0400, Suzanne McCoy
<suzanne.mccoy@CATALINAMARKETING.COM> wrote:

>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
>identification.
>
>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.