The next few screen shots show the old and new designs.Ĭustomer table has a transformation on the StoreID column: So with the new TX2014 SR1 release they added a Set based design to the transformations which added a case when statement to the view. This was done by creating a view from the stage table and adding the function to that view which caused performance issues. The previous versions of TimeXtender used a user defined function to do a transformation. New Features 1 – Set Based Transformations You can build a Type 2 Slowly changing dimension that will record historical data in a few hours where as in traditional SSIS it would take a few days. Historical Data is one of the hardest ETL designs in data warehouses. If you were to build 3 tables from source to stage to DW it would take you a few days in traditional SSIS.īenefit 3 – Type 2 Slowly Changing Dimensions in a Jiffy The formatting and transformations of the data is where you will spend your time but you can have that done in a few hours. You can add 3 source tables and 3 stage tables and 3 Data warehouse tables in a few clicks. It’s a very easy tool to navigate through.īenefit 2 – Data Warehouse Creation Made Easy TimeXtender has a nice visual interface showing you the Source, Stage, and DW areas of you database warehouse all on one screen. I first want to talk about the benefits of the TimeXtender in general and then I will discuss the new features. Many of the things that I felt could help improve the product have really shined in this release. Recently they have released the TX2014 Service Release 1 (SR1) with many new features and benefits from previous releases. Furthermore, TimeXtender works seamlessly with Microsoft SQL Server, MS Analysis Server and other Microsoft BI offerings. TimeXtender is a user friendly “point and click” tool that provides the basis for a BI solution, including data extraction, data validation, data transformation, and the building of data warehouses and OLAP cubes without the need for hard coding the SQL code. TimeXtender has been an integral tool for rapid ETL development and data warehouse automation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |