xvi
10.1.3.2 Automatic Commit versus Automatic Correlated Commit................................ 10-8
10.1.3.3 Embedding Commit Logic into the Mapping....................................................... 10-9
10.1.4 Committing Data Independently of Mapping Design.............................................. 10-10
10.1.5 Running Multiple Mappings Before Committing Data............................................ 10-10
10.1.5.1 Committing Data at Runtime ................................................................................ 10-11
10.1.5.2 Committing Mappings through the Process Flow Editor ................................. 10-12
10.1.6 Ensuring Referential Integrity in PL/SQL Mappings............................................... 10-13
10.2 Best Practices for Designing SQL*Loader Mappings ....................................................... 10-13
10.2.1 Using Conventional Loading to Ensure Referential Integrity in SQL*Loader Mappings
10-13
10.2.1.1 Maintaining Relationships Between Master and Detail Records..................... 10-14
10.2.1.2 Extracting and Loading Master-Detail Records.................................................. 10-15
10.2.1.3 Error Handling Suggestions .................................................................................. 10-17
10.2.1.4 Subsequent Operations........................................................................................... 10-18
10.2.2 Using Direct Path Loading to Ensure Referential Integrity in SQL*Loader Mappings ....
10-18
10.3 Improved Performance through Partition Exchange Loading........................................ 10-21
10.3.1 About Partition Exchange Loading.............................................................................. 10-22
10.3.2 Configuring a Mapping for PEL................................................................................... 10-22
10.3.3 Direct and Indirect PEL ................................................................................................. 10-23
10.3.3.1 Using Indirect PEL .................................................................................................. 10-23
10.3.3.2 Example: Using Direct PEL to Publish Fact Tables ............................................ 10-24
10.3.4 Using PEL Effectively..................................................................................................... 10-24
10.3.5 Configuring Targets in a Mapping............................................................................... 10-25
10.3.5.1 Step 1: Create All Partitions ................................................................................... 10-25
10.3.5.2 Step 2: Create All Indexes Using the LOCAL Option........................................ 10-26
10.3.5.3 Step 3: Primary/Unique Keys Use "USING INDEX" Option ........................... 10-26
10.3.6 Restrictions for Using PEL in Oracle Warehouse Builder ........................................ 10-26
10.4 High Performance Data Extraction from Remote Sources............................................... 10-26
11 Scheduling ETL Jobs
11.1 Overview of Schedules............................................................................................................ 11-1
11.2 Defining Schedules.................................................................................................................. 11-2
11.2.1 Editing Schedules ............................................................................................................. 11-3
11.2.1.1 Start and End Dates and Times ............................................................................... 11-4
11.2.1.2 Defining Schedules To Repeat................................................................................. 11-4
11.2.1.2.1 By Month ............................................................................................................. 11-6
11.2.1.2.2 By Week Number ............................................................................................... 11-6
11.2.1.2.3 By Year Day......................................................................................................... 11-6
11.2.1.2.4 By Month Day..................................................................................................... 11-7
11.2.1.2.5 By Day.................................................................................................................. 11-7
11.2.1.2.6 By Hour................................................................................................................ 11-7
11.2.1.2.7 By Minute ............................................................................................................ 11-7
11.2.1.2.8 By Second ............................................................................................................ 11-7
11.2.1.2.9 By Set Position .................................................................................................... 11-7
11.2.2 Example Schedules........................................................................................................... 11-8
11.3 Applying Schedules to ETL Objects...................................................................................... 11-8
剩余819页未读，继续阅读
weixin_40191861_zj
- 粉丝: 77
- 资源: 1万+
我的内容管理
展开
最新资源
- 多模态联合稀疏表示在视频目标跟踪中的应用
- Kubernetes资源管控与Gardener开源软件实践解析
- MPI集群监控与负载平衡策略
- 自动化PHP安全漏洞检测：静态代码分析与数据流方法
- 青苔数据CEO程永：技术生态与阿里云开放创新
- 制造业转型： HyperX引领企业上云策略
- 赵维五分享：航空工业电子采购上云实战与运维策略
- 单片机控制的LED点阵显示屏设计及其实现
- 驻云科技李俊涛：AI驱动的云上服务新趋势与挑战
- 6LoWPAN物联网边界路由器：设计与实现
- 猩便利工程师仲小玉：Terraform云资源管理最佳实践与团队协作
- 类差分度改进的互信息特征选择提升文本分类性能
- VERITAS与阿里云合作的混合云转型与数据保护方案
- 云制造中的生产线仿真模型设计与虚拟化研究
- 汪洋在PostgresChina2018分享：高可用 PostgreSQL 工具与架构设计
- 2018 PostgresChina大会：阿里云时空引擎Ganos在PostgreSQL中的创新应用与多模型存储
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
