Learn Informatica Cloud IICS
What you’ll learn
Informatica Cloud
Cloud and On-Premise data integration
ETL
Data Integration
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