最新章節
- Index
- Creating a custom cleansing package with Cleansing Package Builder
- Working with the Metapedia functionality
- Performing Metadata Management tasks
- Exploring Data Insight capabilities
- Introduction
品牌：中圖公司
上架時間：2021-08-20 09:55:57
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-20 10:52:54
- Creating a custom cleansing package with Cleansing Package Builder
- Working with the Metapedia functionality
- Performing Metadata Management tasks
- Exploring Data Insight capabilities
- Introduction
- Chapter 12. Introduction to Information Steward
- Loading data into SAP ERP
- Introduction
- Chapter 11. Working with SAP Applications
- Creating real-time jobs
- Configuring Access Server
- The Hierarchy_Flattening transform
- The XML_Map transform
- Working with nested structures
- Introduction
- Chapter 10. Developing Real-time Jobs
- Transforming data with the Pivot transform
- Simplifying ETL execution with system configurations
- Automatic job recovery in Data Services
- Change Data Capture techniques
- Introduction
- Chapter 9. Advanced Design Techniques
- Optimizing dataflow execution – performance options
- Optimizing dataflow loaders – bulk-loading methods
- Optimizing dataflow readers – lookup methods
- Optimizing dataflow execution – the Data_Transfer transform
- Optimizing dataflow execution – the SQL transform
- Optimizing dataflow execution – push-down techniques
- Introduction
- Chapter 8. Optimizing ETL Performance
- Data Quality transforms – cleansing your data
- Enabling dataflow audit
- Using regular expression support to validate data
- Reporting data validation results
- Using validation functions with the Validation transform
- Creating validation functions
- Introduction
- Chapter 7. Validating and Cleansing Data
- Auto Documentation in Data Services
- Using built-in Data Services ETL audit and reporting functionality
- Building an external ETL audit and audit reporting
- Monitoring job execution
- Debugging job execution
- Migrating ETL code with export/import
- Migrating ETL code through the central repository
- Using object replication
- Projects and jobs – organizing ETL
- Introduction
- Chapter 6. Job – Building the ETL Architecture
- Use case example – populating dimension tables
- Controlling failures – try-catch objects
- Using the bypassing feature
- Using conditional and while loop objects to control the execution order
- Nesting workflows to control the execution order
- Creating a workflow object
- Introduction
- Chapter 5. Workflow – Controlling Execution Order
- Monitoring and analyzing dataflow execution
- Splitting the flow of data with the Case transform
- Exploring the Auto correct load option
- Using the Table_Comparison transform
- Using the Map_Operation transform
- Loading data from table to table – lookups and joins
- Loading data from a flat file
- Loading data into a flat file
- Creating a target data object
- Creating a source data object
- Introduction
- Chapter 4. Dataflow – Extract Transform and Load
- Creating custom functions
- Using miscellaneous functions
- Using math functions
- Using aggregate functions
- Using database functions
- Using conversion functions
- Using date functions
- Using string functions
- Creating a script
- Creating variables and parameters
- Introduction
- Chapter 3. Data Services Basics – Data Types Scripting Language and Functions
- Understanding the Designer tool
- Administering tasks
- Starting and stopping services
- Configuring user access
- Installing and configuring Data Services
- Installing and configuring Information Platform Services
- Creating IPS and Data Services repositories
- Introduction
- Chapter 2. Configuring the Data Services Environment
- Creating a target data warehouse
- Defining and creating staging area structures
- Creating a source system database
- Preparing a database environment
- Introduction
- Chapter 1. Introduction to ETL Development
- Customer support
- Reader feedback
- Conventions
- Sections
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- About the Author
- Credits
- 版權頁
- 封面
- 封面
- 版權頁
- 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 更新時間：2021-08-20 10:52:54
