Learn Informatica Cloud IICS

Learn Informatica Cloud – IICS, Oracle, PostgreSql, AWS S3, Flat File, Integrations, Transformations and Monitoring
Learn Informatica Cloud IICS
File Size :
1.31 GB
Total length :
3h 24m

Category

Instructor

Jim Macaulay

Language

Last update

Last updated 7/2022

Ratings

4.1/5

Learn Informatica Cloud IICS

What you’ll learn

Informatica Cloud
Cloud and On-Premise data integration
ETL
Data Integration

Learn Informatica Cloud IICS

Requirements

No programming experience required

Description

Informatica’s product portfolio is focused on data integration: extract, transform, load, information lifecycle management, business-to-business data exchange, cloud computing integration, complex event processing, data masking, data quality, data replication, data virtualization, master data management, ultra messaging, and data governance. These components form a toolset for establishing and maintaining data warehouses.                     Data integration involves combining data residing in different sources and providing users with a unified view of them. This process becomes significant in a variety of situations, which include both commercial (such as when two similar companies need to merge their databases) and scientific (combining research results from different bioinformatics repositories, for example) domains. Data integration appears with increasing frequency as the volume (that is, big data) and the need to share existing data explodes. It has become the focus of extensive theoretical work, and numerous open problems remain unsolved. Data integration encourages collaboration between internal as well as external users. The data being integrated must be received from a heterogeneous database system and transformed to a single coherent data store that provides synchronous data across a network of files for clients. A common use of data integration is in data mining when analyzing and extracting information from existing databases that can be useful for Business information

Overview

Section 1: Introduction

Lecture 1 Introduction to IICS Services

Lecture 2 Runtime Environments

Lecture 3 Secure Agent

Section 2: Connections

Lecture 4 Oracle Connection

Lecture 5 PostgreSql Connection

Lecture 6 Flat File Connection

Section 3: Working with Source and Targets

Lecture 7 Load data from Source to Target

Lecture 8 Source Type – Multiple Objects

Lecture 9 Source Filter

Lecture 10 Source Sorting

Lecture 11 Source PreSql

Lecture 12 Source PostSql

Lecture 13 Source Override

Lecture 14 Target Update

Lecture 15 Target Upsert

Lecture 16 Target Delete

Lecture 17 Execution Properties

Section 4: Transformations

Lecture 18 Expression

Lecture 19 Filter

Lecture 20 Router

Lecture 21 Sorter

Lecture 22 Aggregator

Lecture 23 Joiner

Lecture 24 Joiner – Using Multiple Joiner

Lecture 25 Joiner – Master, Detail and Full Outer

Lecture 26 Connected Lookup

Lecture 27 Unconnected Lookup

Lecture 28 Union

Lecture 29 Sequence Generator

Lecture 30 Rank

Section 5: Tasks

Lecture 31 Mapping Task

Lecture 32 Synchronization Task

ETL Developers,Data Integration Engineers,Data Architects,Database Developers,ETL Architects,Informatica PowerCenter Developers,BI Developers,Data Engineers,Sql Developers

Course Information:

Udemy | English | 3h 24m | 1.31 GB
Created by: Jim Macaulay

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top