Learn Informatica Cloud - IICS

Learn Informatica Cloud - IICS, Oracle, PostgreSql, AWS S3, Flat File, Integrations, Transformations and Monitoring

Created by : Rated :4.1 898 views

Last Updated: 2022-06-30 07:06:43 English Course Type: Self Learning

In this course you can learn end to end ETL process using IICS (Informatica Intelligent Cloud Service)

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

IICS
Sql
ETL
Informatica

ETL Developers
ETL Architects
Data Architects
Data Engineers
Database Developers

Section 1 : Unpublished Section 3 Lectures 00:10:27
Lecture 1 :
Introduction to IICS Services Preview
Lecture 2 :
Runtime Environments
Lecture 3 :
Secure Agent
Section 2 : Connections 3 Lectures 00:08:25
Lecture 1 :
Oracle Connection
Lecture 2 :
PostgreSql Connection
Lecture 3 :
Flat File Connection
Section 3 : Working with Source and Targets 11 Lectures 00:48:48
Lecture 1 :
Load data from Source to Target
Lecture 2 :
Source Type - Multiple Objects
Lecture 3 :
Source Filter
Lecture 4 :
Source Sorting
Lecture 5 :
Source PreSql
Lecture 6 :
Source PostSql
Lecture 7 :
Source Override
Lecture 8 :
Target Update
Lecture 9 :
Target Upsert
Lecture 10 :
Target Delete
Lecture 11 :
Execution Properties
Section 4 : Transformations 13 Lectures 02:02:09
Lecture 1 :
Expression
Lecture 2 :
Router
Lecture 3 :
Filter
Lecture 4 :
Sorter
Lecture 5 :
Aggregator
Lecture 6 :
Joiner
Lecture 7 :
Joiner - Using Multiple Joiner
Lecture 8 :
Joiner - Master, Detail and Full Outer
Lecture 9 :
Connected Lookup
Lecture 10 :
Unconnected Lookup
Lecture 11 :
Union
Lecture 12 :
Sequence Generator
Lecture 13 :
Rank
Section 5 : Tasks 2 Lectures 00:15:33
Lecture 1 :
Mapping Task
Lecture 2 :
Synchronization Task

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Jim Macaulay,

898 Course Views

1 Courses

My self Jim, am an experienced Software and Robotics Engineer with a demonstrated history of working in the financial services industry. Passionate about teaching and blogging. Am also a YouTuber and an instructor. Skilled in Data Engineering with various ETL, Database and Cloud Technologies, and a Robotics Engineer. Strong consulting professional with a Master’s degree focused in Software Systems (Data Analytics) from Birla Institute of Technology and Science, Pilani.