By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

Merge statement for type 2 dimension

P: 1
Hi i am trying to do SCD-2 type logic in a db2 merge statement.

That is..update the old record's end_eff_dt as the existing rows max(eff_dt)-1
and update the new record's end_eff_dt to 2999-12-31. Can anyone help me out here? Thanks!
Oct 9 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.