This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SCD for PostgreSQL

dwhansen-cbg
Contributor

‎02-04-2020 12:25 PM

How would I build a SCD if my target database is PostgreSQL? It doesn’t look like it is an option for PostgreSQL? Is the Diff Snap the way to do it?

0 Kudos
Reply
1 REPLY 1

dwhansen-cbg
Contributor

‎02-05-2020 08:44 AM

For anyone wondering, I’m using a Join Snap with an Outer Join.

If a unique ID field from the left side is null but populated on the right side then it is a deleted record.
If a unique ID field from the left side is populated but null on the right side then it is a new record.
If a unique ID field from the left side and right side are both populated then the it is an existing record.

0 Kudos
Reply