Visão Geral

Curso Workshop Informatica Cloud Data Integration for Developers. Aprenda os fundamentos do Informatica Intelligent Cloud Services (IICS), incluindo os recursos de arquitetura e integração de dados, tarefas de sincronização, designer de mapeamento em nuvem, mapeamentos DI, mapplets, parâmetros de mapeamento, tarefas de mascaramento e tarefas de replicação.

Objetivo

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

• Descrever a arquitetura do Informatica Cloud
• Criar tarefa de sincronização
• Criar tarefa de transferência de dados
• Use o Cloud Mapping Designer para criar mapeamentos
• Use transformações de pesquisa e joiner
• Crie Mapplets e trabalhe com eles
• Criar parâmetros em um mapeamento
• Discuta tarefas de mapeamento
• Crie uma tarefa de replicação
• Crie uma tarefa de mascaramento
• Crie fluxos de tarefas
• Use serviços da web IICS REST para DI

Publico Alvo

• Desenvolvedor

Materiais

Conteúdo Programatico

Informatica Cloud Overview

1. Informatica Intelligent Cloud Services (IICS) as an iPaaS solution
2. Using IICS for ETL
3. Informatica Cloud Terminologies
4. Informatica Cloud Architecture
5. IICS Interface Walkthrough
6. IICS Services
7. Lab: Navigating the IICS Interface

Introduction to Data Integration Service

1. Discuss Data Integration Service
2. Pre-requisites to work with Data Integration Service
3. Discuss CDI Assets
4. Describe CDI Components

Synchronization Task

1. Synchronization Task Overview
2. Synchronization Task – Definition Step
3. Synchronization Task – Source Step
4. Synchronization Task – Target Step
5. Synchronization Task – Data Filters Step
6. Synchronization Task – Field Mapping Step
7. Synchronization Task – Schedule Step
8. Lab: Creating a Salesforce Connection
9. Lab: Creating a Synchronization Task
10. Lab: Using Filter, Expression, and Lookup in a Synchronization Task
11. Lab: Using Saved Query in a Synchronization Task
12. Lab: Using Upsert Operation in Synchronization Task

Data Transfer Task

1. Data Transfer Task Overview
2. Data Transfer Task – Definition Step
3. Data Transfer Task – Source Step
4. Data Transfer Task – Second Source Step
5. Data Transfer Task – Target Step
6. Data Transfer Task – Field Mapping Step
7. Data Transfer Task – Runtime Options Step
8. Lab: Creating a Data Transfer Task

Basics of Cloud Mapping Designer

1. Cloud Mapping Designer Overview
2. Types of Mappings
3. Mapping Designer Terminologies
4. Mapping Templates
5. Defining Data Flow Fun Order
6. Field Rules
7. Best Practices for Creating Mappings

IICS Transformations

1. Source Transformation
2. Target Transformation
3. Aggregator Transformation
4. Filter Transformation
5. Expression Transformation
6. Union Transformation
7. Rank Transformation
8. Sorter Transformation
9. Router Transformation
10. Lab: Classifying the Product Shipping Details using various Transformations
11. Lab: Using Union, Sorter, and Rank Transformations in a Mapping

Joiner and Lookup Transformations

1. Joiner Transformation Overview
2. Join Condition
3. Join Type - Normal Join, Master outer, Detail Outer, Full Outer
4. Lookup Transformation
5. Lab: Using Lookup Transformation in a Mapping
6. Lab: Merging Current and Previous Data Loads Using Full Outer Join

Mapplets

1. Mapplets Overview
2. Active and Passive mapplet
3. Types of IICS mapplets
4. Mapplets Input and Output
5. Parameters in mapplets
6. PowerCenter mapplet
7. Create mapplet in IICS
8. Mapplet Transformation
9. Lab: Using Mapplet Transformation in a Mapping
10. Lab: Create Mapplet and Use it in the Existing Mapping
11. Lab: Creating a Mapping using Existing Mapplet and Aggregator Transformations

Mapping Parameterization

1. What is Parameterization
2. Parameterization use case
3. Steps to add Parameters to a Mapping
4. Creating parameters in a mapping
5. Parameter Types
6. Using parameter files
7. In-Out Parameter in Mapplet
8. Parameter File Directory
9. Parameter Best Practices
10. Lab: Performing Complete Parameterization
11. Lab: Using In-Out Parameters for Incremental Data Loading

Mapping Task

1. Mapping Task overview
2. Deploy mapping updates
3. Field Masking Rules
4. Data Masking Transformation
5. Simultaneous task runs
6. Lab: Create a Mapping Task and Configure Advanced Settings

Replication Task

1. Replication Task Overview
2. Replication Task Features
3. Replication Task: Source and Target Options
4. Other Replication Task Options
5. Resetting the Target Table
6. Generating Non-Unique Index
7. Lab: Replicating Data to a Flat File

Masking Task

1. Masking Task Overview
2. Masking Task: Source and Target Options
3. Data Subset: Row Limits and Data Filters
4. Field Masking Rules
5. Masking Rule Types
6. Refresh Masking Task metadata
7. Reset a Masking Task
8. Masking Best Practices
9. Data Masking Transformation
10. Lab: Creating a Masking Task
11. Lab: Using Data Masking Transformation in a Mapping

Taskflows

1. Taskflow overview
2. Linear Taskflows
3. Taskflow Steps
4. Taskflow Templates
5. Parameters in Taskflow
6. Error handling in Taskflows
7. Lab: Creating a Linear Taskflow
8. Lab: Creating a Taskflow with Conditional Logics

IICS REST APIs

1. REST API overview
2. Informatica Cloud REST API
3. List of supported REST API Versions
4. Using REST APIs
5. Creating REST V2 Connector
6. Web Service Transformation
7. Lab: Creating a Mapping Using a REST V2 Connector
8. Lab: Using Web Services Transformation in a Mapping
9. Lab: Running a Mapping Task Using REST API
10. Lab: Monitoring Tasks Using REST API