{"id":102,"date":"2005-12-02T11:07:52","date_gmt":"2005-12-02T18:07:52","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/?p=102"},"modified":"2005-12-02T11:07:52","modified_gmt":"2005-12-02T18:07:52","slug":"best-etl-for-this-in-oracle","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2005\/12\/02\/best-etl-for-this-in-oracle\/","title":{"rendered":"Best ETL for this in Oracle?"},"content":{"rendered":"<p>I&#8217;m usually posting pictures about fancy new features in OWB Paris, and doling out little tidbits about how to this and that&#8230; I thought I&#8217;d change it up a bit and ask a question!  Now that I&#8217;ve got comments working I can do fun things like that!  I don&#8217;t want to influence any ideas so I won&#8217;t mention how I would go about this, so, here &#8217;tis.<\/p>\n<p>What is the most EFFECIENT way using Oracle SQL to calculate effective\/expiration for denormalized tables?  ie, if you have two tables with the SAME natural key with their own set of effective\/expiration dates what is the most EFFICIENT SQL to generate a new denormalized table with accurate effective\/expiration dates?<\/p>\n<p>Consider the following example ERD:<br \/>\n<img decoding=\"async\" src=\"\/entry_images\/etl_for_this_image.gif\" border=\"0\"><\/p>\n<p>What&#8217;s everyones favorite solution?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m usually posting pictures about fancy new features in OWB Paris, and doling out little tidbits about how to this and that&#8230; I thought I&#8217;d change it up a bit and ask a question! Now that I&#8217;ve got comments working I can do fun things like that! I don&#8217;t want to influence any ideas so [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/102"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=102"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/102\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}