Technology Use – Page 3

The Data Warehouse Lifecycle Toolkit

February 24, 2025February 22, 2022 by Julian.Kellett

Expert Methods for Designing, Developing and Deploying Data Warehouses

Recent Comments

Julian.Kellett on Global.Company
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}
Julian.Kellett on Global.Organisation
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}
Julian.Kellett on BusOpp.Dates
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.PurchaseOrderline
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.Invoice
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on Supplier.Details
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}
Julian.Kellett on BusOpp.Dates
Expected Condition The DataMart View BusOpp.Dates is in the style of 202409 As Found Condition The unversioned (beta) edition of…
Ali Ahmed on How to Find the SQL Definition of a View in Oracle
Double check your WITH READ ONLY — it’s typically only used on views, not raw SELECT queries unless you're defining…
Julian.Kellett on Resource.Details
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Cross Apply version"}
Julian.Kellett on Employee.Hours
{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"CTE Version"}