Building Blocks of Biml Год выпуска: 12/2015 Производитель: Pluralsight Сайт производителя: pluralsight.com/courses/building-blocks-biml Автор: Stacia Misner Varga Продолжительность: 4:10 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: It’s generally accepted that creating and maintaining ETL packages with SQL Server Integration Services (SSIS) is one of the more time-consuming steps in the data warehouse development process, but what if there was a way to save time that can be used to solve bigger problems or expand the data warehouse scope? Rather than spend seemingly endless hours working through repetitive SSIS package development tasks and more hours tweaking those packages as schemas evolve, you can use Biml to create a framework that gracefully adapts to changes and updates package designs in minutes. This course introduces you to the Biml language by progressively building out files to support a data warehouse environment until you have a complete solution for staging data and loading the staged data into target dimension and fact tables. Общепринято, что создание и поддержка etl пакетов с SQL сервером служб интеграции (ssis) - это один из наиболее трудоемких этапов в процессе разработки хранилища данных, но что если есть способ сэкономить время, которое можно использовать для решения серьезных проблем или расширить объем хранилища данных? Вместо того чтобы тратить бесконечные часы работающие через повторяющихся пакетов служб ssis задач разработки и более часов настройки этих пакетов, как развиваются схемы, вы можете использовать Мбзм создать механизм, который изящно подстраивается под изменения и обновления дизайна упаковки в течение нескольких минут. Этот курс знакомит вас с Мбзм языка, постоянно пополняя файлы для поддержки среды хранения данных до тех пор, пока у вас есть комплексное решение для промежуточного хранения данных и загрузки промежуточных данных в створ таблиц измерений и фактов.
Содержание
Introducing Biml 34m 55s Introducing Biml 0m 58s History of Biml 2m 43s Problems Solved by Biml 2m 33s Demo: Updating Packages for a Schema Change 2m 38s Demo: Updating Packages for a Schema Change - Part 2 6m 38s Tools for Biml 0m 41s BIDS Helper 2m 21s SQL Server Data Tools (or BIDS) 0m 49s Demo: Configuring Visual Studio for Biml 3m 59s Demo: Updating Packages with Biml 2m 38s Notepad++ 1m 13s Demo: Configuring Notepad++ for Biml 2m 33s Optional: Mist Cloud 0m 39s Demo: Using the Mist Cloud Application 2m 56s Summary 1m 30s Creating Your First Biml Files 29m 7s Creating Your First Biml Files 1m 10s Biml File Structure 2m 24s Demo: Creating a Package 3m 57s Online Documentation 1m 2s Demo: Exploring Online Documentation 4m 29s Sequence Containers and Constraint Modes 1m 41s Demo: Using the Constraint Mode Attribute 4m 4s Simple Elements and Attributes 0m 28s Connections 1m 29s Tasks 1m 20s Task Attributes 0m 49s Demo: Adding Connections and Tasks 5m 16s Summary 0m 53s Exploring Basic Biml Syntax in the Control Flow 27m 38s Exploring Basic Biml Syntax in the Control Flow 0m 54s Precedence Constraints 0m 43s Demo: Working with Precedence Constraints - Part 1 6m 11s Precedence Constraints with Options 1m 14s Demo: Working with Precedence Constraints - Part 2 3m 5s Special Characters in Expressions 0m 56s Demo: Working with Special Characters 4m 8s More ExecuteSQL Biml 1m 6s Data Types - a Sampling 0m 47s Variables 0m 51s ExecuteSQL ResultSet 0m 37s Demo: Configuring Execute SQL Tasks 6m 0s Summary 1m 0s Exploring Basic Biml Syntax in the Data Flow 29m 46s Exploring Basic Biml Syntax in the Data Flow 1m 7s Data Flow Source 1m 47s Data Flow Destination 1m 2s Demo: Adding a Data Flow Source and Destination 4m 42s Transformations 1m 20s Demo: Adding Data Flow Transformations 3m 11s Pipeline Path Management 2m 0s Demo: Working with Component Outputs 4m 10s Error Handling 0m 43s Flat File Connection, Format, and Destination 2m 18s Demo: Error Handling 5m 39s Summary 1m 43s Introducing Biml Automation 20m 16s Introducing Biml Automation 0m 41s BimlScript 1m 43s BimlScript Components 0m 36s Directives 1m 27s Text Blocks 0m 27s Control Blocks 2m 3s Demo: Automating Biml with Control Blocks 6m 13s MessageBox for Troubleshooting 0m 28s Assembly Directive 0m 39s MessageBox.Show() Method 0m 25s Import Directive 0m 27s Demo: Adding a Message Box 3m 55s Summary 1m 7s Automating Biml with Multiple Files 39m 23s Automating Biml with Multiple Files 1m 13s RootNode 0m 35s Template Directive with Tier Attribute 1m 9s Package Template 1m 15s GetDatabaseSchema() Extension Method 1m 34s Tables and Table Elements 1m 44s Demo: Building a Package Template - Part 1 5m 47s Demo: Building a Package Template - Part 2 7m 8s GetBiml() Method 1m 25s Demo: Retrieving Biml from Project Objects 3m 13s Include Directive 0m 35s Demo: Using the Include Directive 5m 30s CallBimlScript() 1m 9s Demo: Using the CallBimlScript() Method 6m 3s Summary 0m 57s Building Biml for Data Warehousing - Part 1 23m 27s Building Biml for Data Warehousing - Part 1 0m 46s Framework 1m 22s Staging Tables 0m 33s GetTableSQL() 0m 44s Demo: Creating Deploy Staging table Package 7m 51s Extract Packages 0m 50s Annotations 1m 16s Where Filter 0m 49s Demo: Creating Extract Packages 8m 16s Summary 0m 55s Building Biml for Data Warehousing - Part 2 45m 49s Building Biml for Data Warehousing - Part 2 0m 50s Load Packages - Dimensions 1m 2s Where as Table Filter in Model 0m 37s Annotation Tags for Tables to Load 0m 39s Class Feature Control Block 0m 45s Lookup 1m 9s Conditional Split 0m 42s Demo: Creating Dimension Load Packages - Part 1 5m 4s Demo: Creating Dimension Load Packages - Part 2 4m 28s Demo: Creating Dimension Load Packages - Part 3 7m 33s Load Packages - Facts 1m 28s Aggregate 0m 41s OLE DB Command 0m 54s Expression 0m 48s Demo: Creating Fact Load Packages 8m 2s Master Packages 3m 16s Demo: Creating Master Packages 6m 55s Summary 0m 48s
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}