18:30 - 18:45 - Introduction, Networking and Food
18:45 - 19:45 – Creating a cube with SSAS
Chris Testa O'Neill
This session will provide an overview of the steps required to create a cube in SQL Server Analysis Services. Exploring the use of Data Sources and data source views to define the source data that the cube will use. Understanding the importance of Dimensions and how hierarchies can be added to improve the user experience of browsing a dimensional data . To bringing the cube together with measures that will hold the business metrics that intersect each dimension in a cube.
Take this tour that will show you how to build a cube from the ground up, providng you with the ability to create you very own cubes so that you can query your data far more effectively
19:45 - 20:00 – Break
20:00 - 21:00 – Attunity CDC Product Demonstration
Ian will discuss what change data capture (CDC) is, why it is used and its increasing importance in the integration portfolio. He'll explain a number of ways it can be achieved and why Attunity chose the particular method they use. Ian will then present the typical architecture of an Attunity based CDC solution and demonstrate Attunity’s CDC for SSIS suite showing how data can be efficiently replicated across heterogeneous systems