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: Create a Dynamic Mapping Task

Module 3: User Defined Functions

• Explain User Defined Functions
• Create UDF
• Edit and Delete UDF
• Lab: Creating User Defined Functions

Module 4: Transaction Control Transformation

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

Module 5: Dynamic Schema Handling

• Explain 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

• Discuss Advanced Taskflow Techniques
• Explain File Listeners
• Configure a File Listener
• Invoke 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

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

Module 8: Advanced Parameterization

• Explain Use of Parameter File
• Discuss Retention Policy
• Describe the Aggregation Type
• Cloud Hosted Parameter File
• Lab: Using Parameter File in a Mapping

Module 9: Data Ingestion and Replication

• Data Ingestion and Replication Task Overview
• Configuring a Data Ingestion and Replication Task
• Application Ingestion and Replication Task
• File Ingestion and Replication Task
• Database Ingestion and Replication Task
• Streaming Ingestion and Replication Task
• Demo: Create Database 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

• Explain Normalizer Transformation
• Describe 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
• Demo: 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 IICS

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