Visão Geral

Este Curso Workshop Informatica Cloud Data Integration for Developers, Advanced aborda os recursos avançados do Informatica Intelligent Cloud Services, como uso de macros de expressão, tarefas de mapeamento dinâmico, listeners de arquivos, tratamento de alterações e erros de esquema dinâmico, execução de descoberta de estrutura, otimização de empilhamento, particionamento e uso de transformação avançada em designers de mapeamento de nuvem.

Objetivo

Depois de concluir com êxito este Curso Workshop Informatica Cloud Data Integration for Developers, Advanced, os alunos deverão ser capazes de:

• Use transformações avançadas no Cloud Mapping Designer
• Use macros em um mapeamento
• Crie uma tarefa de mapeamento dinâmico
• Lidar com alterações de esquema dinâmico
• Use o ouvinte de arquivo para automação de tarefas
• Usar o construtor de hierarquia e as transformações do analisador
• Use a descoberta inteligente de estrutura
• Usar a transformação Pesquisa Desconectada em um mapeamento
• Executar otimização de empilhamento em um mapeamento
• Execute vários tipos de particionamento
• Execute o tratamento de erros no IICS
• Discuta o ajuste de desempenho no IICS

Publico Alvo

• Desenvolvedor

Pre-Requisitos

• Integração de dados em nuvem para desenvolvedores

Materiais

Conteúdo Programatico

IICS Transformations

1. Normalizer Transformation
2. SQL Transformation
3. Transaction Control Transformation
4. Sequence Generator Transformation
5. Velocity Transformation
6. Schema Change Handling
7. Lab: Using Transaction Control Transformation in a Mapping
8. Lab: Using Normalizer Transformation in a Mapping to Transform Consolidated Data
9. Lab: Create Expression Macro in a Mapping
10. Lab: Using Vertical Macro in a Mapping
11. Lab: Using Horizontal Macro in a Mapping
12. Lab: Create Dynamic Schema Change Handling

Dynamic Mapping Task

1. Overview of Dynamic Mapping Task
2. Parameters in Dynamic Mapping Task
3. Jobs and Job Groups
4. Configuring a Dynamic Mapping Task
5. Lab: Create a Dynamic Mapping Task

File Listeners

1. File Listeners overview
2. Using File Listeners
3. Steps to configure a File listener
4. Invoke a Taskflow through a File Listener
5. Lab: Passing In-out Parameters in a Taskflow
6. Lab: File Listener as a Step — Version 1
7. Lab: File Listener as a Step — Version 2
8. Lab: Invoking a Taskflow through a File Listener

Hierarchical Connectivity

1. Hierarchical Schemas
2. Hierarchy Parser Transformation
3. Hierarchy Builder Transformation
4. Lab: Using Hierarchy Parser and Hierarchy Builder Transformation

Intelligent Structure Model

1. Intelligent Structure Model
2. Intelligent Structure Discovery Process
3. Intelligent Structure Example
4. Refining a Discovered Structure
5. Intelligent structure models based on MS Word file
6. Using intelligent structure models in Structure Parser transformation
7. Lab: Using Structure Parser Transformation in a Mapping

Mass Ingestion Task

1. Mass Ingestion Task Overview
2. Configuring a Mass Ingestion Task
3. Application Ingestion Task
4. File Ingestion Task
5. Database Ingestion Task
6. Streaming Ingestion Task
7. Lab: Creating a Streaming Ingestion Task
8. Lab: Creating a File Ingestion Task

Exception Handling

1. Types of exceptions
2. User-defined exceptions
3. Non-fatal exceptions
4. Default Field Value Setting
5. Row Error Logging
6. Performing recovery in IICS
7. Error handling settings
8. Fatal exceptions
9. Bad files or Reject files
10. Lab: Creating a Mapping to Handle Non-fatal Errors

Performance Tuning/Advanced Task Settings

1. Partitions Overview
2. Types of Partitions
3. Partitioning Rules and Guidelines
4. Pushdown optimization overview
5. Types of pushdown optimization
6. Pushdown optimization user-defined parameters
7. DTM performance properties
8. Unconnected Lookup
9. Lab: Performing Pushdown Optimization in IICS
10. Lab: Performing Partitioning
11. Lab: Creating a Mapping Using Unconnected Lookup Transformation

Appendix: Advanced Integration

1. Introduction
2. Advantages of Advanced Integration
3. Advanced Serverless