Similar Posts
Tutorial 1 – Wizard
LinkedIn Twitter
Conversations with Data Warehouse Experts – James Rowland-Jones
In this episode I speak with James Rowland-Jones (JRJ), Principal Program Manager for Microsoft. He is passionate about delivering highly scalable solutions that are creative, simple and elegant in their design. James specializes in scale out data solutions such as Azure SQL Data Warehouse, Microsoft Analytics Platform System and Hadoop. JRJ is a keen advocate…
Conversations with Data Warehouse Experts – John Johansen at Majesco
In this episode, it is my pleasure to speak with John Johansen, Senior Vice President, Consulting Services Strategy & Innovation at Majesco, a leading provider of insurance solutions and services. He is a highly skilled consultant and data architect known for his ability to help insurers build effective data organizations. He is an entrepreneur who exited…
Tutorial 1 – Run ETL Batch
LinkedIn Twitter
Creating and Using a Derived Staging Table
What is a derived staging table? It’s a table created in your Staging database that derives its data from other already existing Staging tables. Its useful for creating aggregations, or allocations of data prior to the transform and load process into your Data Warehouse. It can also be useful for tables that don’t have any…
New managed Incremental Extract Pattern
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” text_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid”] Dimodelo Data Warehouse Studio now allows you to extract only changed data from your source system, reducing load on your source systems and overall ETL duration. I.e. To do change data capture (CDC) at the source. Dimodelo Data Warehouse Studio now includes a managed…