Cloud Data Integration
for Developers, Advanced 

Module 1: IDMC Architecture

• Explain IDMC Architecture
• New Components in IDMC

Module 2: Dynamic Mapping Task

• Overview of Dynamic Mapping Task
• Parameters in Dynamic Mapping Task
• Jobs and Job Groups
• Configuring a Dynamic Mapping Task
• Lab: Creating a Dynamic Mapping Task

Module 3: User Defined Functions

• Explaining User Defined Functions
• Creating UDF
• Editing and Deleting UDF
• Lab: Creating User Defined Functions

Module 4: Transaction Control Transformation

• Explaining Transaction Control Transformation
• Use of TCT
• Guidelines for using TCT
• Lab: Using Transaction Control Transformation in a Mapping

Module 5: Dynamic Schema Handling

• Explaining Schema Change Handling
• Dynamic Schema Change Handling
• Limitations of Dynamic Schema Change Handling
• Schema Handling Options
• Lab: Handling Dynamic Schema Change in a Mapping

Module 6: Advanced Taskflow Techniques with File Listener

• Discussing Advanced Taskflow Techniques
• Explaining File Listeners
• Configuring a File Listener
• Invoking a Taskflow through a File Listener
• Lab: Passing Values from Mapping to Mapping
• Lab: Using File Listener as a Step — Version 1
• Lab: Using File Listener as a Step — Version 2

Module 7: Dynamic Lookup Cache

• Discussing Dynamic Lookup Cache
• Field Mapping in Dynamic Lookup Cache
• Use case of Dynamic Lookup Cache

Module 8: Advanced Parameterization

• Explaining Use of Parameter File
• Discussing Retention Policy
• Describing the Aggregation Type
• Cloud Hosted Parameter File
• Lab: Using Parameter File in a Mapping

Module 9: Data Ingestion and Replication Task

• Data Ingestion and Replication Task Overview
• Application Ingestion and Replication Task
• File Ingestion and Replication Task
• Database Ingestion and Replication Task
• Streaming Ingestion and Replication Task
• Lab: Creating a Streaming Ingestion and Replication Task
• Lab: Creating a File Ingestion and Replication Task

Module 10: Exception Handling

• Types of Exceptions
• User-defined Exceptions
• Non-fatal and Fatal Exceptions
• Exception Handling Techniques
• Bad Files or Reject Files
• Lab: Creating a Mapping to Handle Non-fatal Errors

Module 11: Normalizer Transformation

• Explaining Normalizer Transformation
• Describing Normalized Fields
• Normalizer Filed Mapping
• Lab: Using Normalizer Transformation in a Mapping to Transform Consolidated Data

Module 12: Hierarchical Connectivity

• Hierarchical Schemas
• Hierarchy Parser Transformation
• Hierarchy Builder Transformation
• Lab: Using Hierarchy Parser and Hierarchy Builder Transformations

Module 13: Intelligent Structure Model

• Intelligent Structure Model
• Intelligent Structure Discovery Process
• Intelligent Structure Example
• Refining a Discovered Structure
• Intelligent Structure Models based on MS Word File
• Using Intelligent Structure Models in Structure Parser Transformation
• Lab: Creating an Intelligent Structure Model
• Lab: Using Structure Parser Transformation in a Mapping

Module 14: SQL ELT Optimization

• SQL ELT Optimization Overview
• Types of SQL ELT Optimization
• SQL ELT Optimization in Advanced Mode
• Lab: Performing SQL ELT Optimization in IDMC

Module 15: Mapping Partitioning

• Partitions Overview
• Types of Partitions
• Partitioning Rules and Guidelines
• Lab: Performing Partitioning

Appendix: Advanced Integration

• Introduction
• Advantages of Advanced Integration
• Advanced Serverless