Informatica IDMC – Cloud Data Integration B23
Weekday – 7:00 AM to 8:30 AM, IST
-
Introduction & Session Joining Page
-
Session Recordings 01 to 10Day 01 – IICS, BI, Data Warehouse, and Data Lake1h 26m 10sDay 02 IICS, Dimension and Fact tables, Data modeling, OLAP CUBE1h 17m 56sDay 3 – IICS trial account, secure agent installation- 03-Jul-20241h 16m 48sDay 4 – IICS Introduction, Architecture, Secure agent – 04-Jul-20241h 38m 49sDay 5 – IICS Tool overview, First mapping and data load – 05-Jul-20241h 42m 55sDay 6 – IICS Flat File to Table, Table to FF load – 08-Jul-20241h 32m 43sDay 7 – Multiple delimiter, Fixed Width file, File List – 09-Jul-20241h 26m 14sDay 8 – File with Unicode characters, File validations, Excel source – 10-Jul-20241h 17m 28sDay 09 – XML, JSON Files Load, Hierarchical schema, Parser and Builder – 14-Feb-20241h 6m 51sDay 10 – Snowflake trial account creation, data load – 12-Jul-20241h 25m 32s
-
Session Recordings 11 to 20Day – 11 – Salesforce trial account creation, data load – 15-Jul-20241h 13m 17sDay 12 – Source Transformation, and its properties – 16-Jul-20241h 28m 53sDay 13 – Source Join, Source Query, Filter Transformation – 17-Jul-20241h 37m 32sDay 14 – Joiner, Sorter and Aggregator Transformation, Sorted input – 18-Jul-20241h 46m 29sDay 15 – Expression Transformation, Unit testing – 19-Jul-20241h 18m 39sDay 16 – Expression Macros, Router and Rank Transformation, Dense_Rank – 22-Jul-20241h 27m 46sDay 17 – Lookup Transformation, connected, Unconnected lookup – 23-Jul-20241h 10m 24sDay 18 – LKP Multiple column return, Lookup policy, Union Transformation – 24-Jul-20241h 13m 4sDay 19 – Sequence generator, shared sequence, Transaction control transformation – 25-Jul-20241h 24m 32sDay 20 – Normalizer, Java Transformation, SQL Transformation – 26-Jul-20241h 30m 58s
-
Session Recordings 21 to 31Day 21 – Target Transformation, SCD type-1, MD5 Implementation – 29-Jul-20241h 19m 7sDay 22 – Web service, API, REST API, Webservice Transformation- 31-Jul-20241h 13m 38sDay 23 – SCD Types, Type 2 implementation, Flag and Date methods- 05-Aug-20241h 25m 27sDay 24 – IICS – AWS Trial account creation and data load to S3 – 06-Aug-20241h 16m 16sDay 25 – Different task in IICS, Replication, synchronization, PC, Dynamic task- 07-Aug-20241h 13m 10sDay 26 – IICS – GCP Trial account, data load to Big Query and GCS – 08-Aug-20241h 17m 20sDay 27 – IICS – Parameters and Variables, set max variable – 09-Aug-20241h 24m 17sDay 28 – IICS – Mapplet, UDF, Taksflow, linear taskflow – 13-Aug-20241h 16m 58sDay 29 – IICS – taskflow and different taskstep, scenarios – 14-Aug-20241h 8m 4sDay 30 – Performance tuning in IICS, PDO, Partitioning – 15-Aug-20241h 25m 44sDay 31- Lookup cache, dynamic cache, SCD Type-2, persistent cache – 16-Aug-20241h 31m 36s
-
Project level sessions – 32, 33, 34 and 35Day 32 – IICS – SDLC life cycle, Different environment, responsibilities- 19-Aug-20241h 34m 32sDay 33 – IICS – ETL Project session 2, Agile, ETL Tools, Jira, EDW arch – 20-Aug-20241h 33m 23sDay 34 – IICS – ETL Project session 3, Scheduler, complex issues, certification – 21-Aug-20241h 14m 35sPowerCenter to Informatica Cloud migration58m 15s
-
Quiz Section
Informatica IICS – CDI
We provide the most comprehensive, career-oriented, instructor-led Informatica IICS/IDMC CDI online training. Get hands-on experience configuring Informatica IICS, Transformation logic, working with Cloud providers like AWS, GCP, and Snowflake, performance tuning, IICS migration, and more.
📌 Complete Hands-on session
📌Daily exercise for practice
📌Resume preparation session(with 6 sample resumes)
📌Roles and responsibility session
📌Interview preparation session
📌Complex scenario session
📌Project architecture session
📌Interview questions and answers
📌Powercenter to IICS Migration
What we covered in this course?
Business Intelligence, Data Warehouse, and Data Lake Concepts
IICS Installation
IICS architecture
Different flat files, .csv, excel, JSON and XML data load
All the transformations logic and hands-on
GCP trial account creation and data load
Snowflake trial account creation and data load
AWS Trial account creation and data load
Lookup caches, performance Tuning
Parameter and variables
Different tasks and task flows in IICS
Resume Preparation
Interview questions and answers
Project level sessions
