目錄(112章)
倒序
- 封面
- 版權(quán)頁
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Sections
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Introduction to ETL Development
- Introduction
- Preparing a database environment
- Creating a source system database
- Defining and creating staging area structures
- Creating a target data warehouse
- Chapter 2. Configuring the Data Services Environment
- Introduction
- Creating IPS and Data Services repositories
- Installing and configuring Information Platform Services
- Installing and configuring Data Services
- Configuring user access
- Starting and stopping services
- Administering tasks
- Understanding the Designer tool
- Chapter 3. Data Services Basics – Data Types Scripting Language and Functions
- Introduction
- Creating variables and parameters
- Creating a script
- Using string functions
- Using date functions
- Using conversion functions
- Using database functions
- Using aggregate functions
- Using math functions
- Using miscellaneous functions
- Creating custom functions
- Chapter 4. Dataflow – Extract Transform and Load
- Introduction
- Creating a source data object
- Creating a target data object
- Loading data into a flat file
- Loading data from a flat file
- Loading data from table to table – lookups and joins
- Using the Map_Operation transform
- Using the Table_Comparison transform
- Exploring the Auto correct load option
- Splitting the flow of data with the Case transform
- Monitoring and analyzing dataflow execution
- Chapter 5. Workflow – Controlling Execution Order
- Introduction
- Creating a workflow object
- Nesting workflows to control the execution order
- Using conditional and while loop objects to control the execution order
- Using the bypassing feature
- Controlling failures – try-catch objects
- Use case example – populating dimension tables
- Chapter 6. Job – Building the ETL Architecture
- Introduction
- Projects and jobs – organizing ETL
- Using object replication
- Migrating ETL code through the central repository
- Migrating ETL code with export/import
- Debugging job execution
- Monitoring job execution
- Building an external ETL audit and audit reporting
- Using built-in Data Services ETL audit and reporting functionality
- Auto Documentation in Data Services
- Chapter 7. Validating and Cleansing Data
- Introduction
- Creating validation functions
- Using validation functions with the Validation transform
- Reporting data validation results
- Using regular expression support to validate data
- Enabling dataflow audit
- Data Quality transforms – cleansing your data
- Chapter 8. Optimizing ETL Performance
- Introduction
- Optimizing dataflow execution – push-down techniques
- Optimizing dataflow execution – the SQL transform
- Optimizing dataflow execution – the Data_Transfer transform
- Optimizing dataflow readers – lookup methods
- Optimizing dataflow loaders – bulk-loading methods
- Optimizing dataflow execution – performance options
- Chapter 9. Advanced Design Techniques
- Introduction
- Change Data Capture techniques
- Automatic job recovery in Data Services
- Simplifying ETL execution with system configurations
- Transforming data with the Pivot transform
- Chapter 10. Developing Real-time Jobs
- Introduction
- Working with nested structures
- The XML_Map transform
- The Hierarchy_Flattening transform
- Configuring Access Server
- Creating real-time jobs
- Chapter 11. Working with SAP Applications
- Introduction
- Loading data into SAP ERP
- Chapter 12. Introduction to Information Steward
- Introduction
- Exploring Data Insight capabilities
- Performing Metadata Management tasks
- Working with the Metapedia functionality
- Creating a custom cleansing package with Cleansing Package Builder
- Index 更新時(shí)間：2021-08-20 10:52:54
推薦閱讀
- Python編程自學(xué)手冊
- Hands-On Enterprise Automation with Python.
- Functional Kotlin
- Mastering Ext JS
- 區(qū)塊鏈底層設(shè)計(jì)Java實(shí)戰(zhàn)
- Python算法指南：程序員經(jīng)典算法分析與實(shí)現(xiàn)
- 鴻蒙OS應(yīng)用編程實(shí)戰(zhàn)
- BeagleBone Robotic Projects（Second Edition）
- 從Excel到Python數(shù)據(jù)分析：Pandas、xlwings、openpyxl、Matplotlib的交互與應(yīng)用
- C#面向?qū)ο蟪绦蛟O(shè)計(jì)（第2版）
- Java程序設(shè)計(jì)教程
- OpenCV 3.0 Computer Vision with Java
- ASP.NET Core and Angular 2
- Mastering Object：Oriented Python（Second Edition）
- Scratch少兒編程高手的7個(gè)好習(xí)慣
- Mastering Magento Theme Design
- Windows 10 for Enterprise Administrators
- Tkinter GUI Application Development Blueprints
- Arduino Robotic Projects
- OpenACC并行編程實(shí)戰(zhàn)
- Spring Batch Essentials
- C語言從入門到精通（第6版）
- 零基礎(chǔ)Python學(xué)習(xí)筆記
- 架構(gòu)真意：企業(yè)級(jí)應(yīng)用架構(gòu)設(shè)計(jì)方法論與實(shí)踐
- 網(wǎng)絡(luò)安全Java代碼審計(jì)實(shí)戰(zhàn)
- Robot Framework 自動(dòng)化測試框架核心指南
- 步步為贏：交互設(shè)計(jì)全流程解析
- Complete Virtual Reality and Augmented Reality Development with Unity
- 區(qū)塊鏈+：從全球50個(gè)案例看區(qū)塊鏈的技術(shù)生態(tài)、通證經(jīng)濟(jì)和社區(qū)自治
- 3D Printing with SketchUp
