Course Overview
This course is designed to teach Informatica’s Intelligent Cloud Services advanced topics and performance and tuning. Focus on web services, REST APIs, and special advanced transformations like Java and transaction control. Recommended for developers with a few months’ experience with IICS. Practical advanced labs designed to enhance in-depth knowledge of IICS.
Target audiences
- Developers
Curriculum
- 1 Section
- 7 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics7
- 1.1Informatica Cloud Overview 1. Advanced mapping Techniques Local Variables Advanced usage Data Pivot: Normalizing & Denormalizing Techniques Joiner Advanced technique: Self Join & sorted input Dynamic lookups Dynamic Mapping Task Dynamic Schema Change Exercise #1: Denormalizer, Self Join and Dynamic lookup Slowly Changing Dimension Type II & III and IV(MappingTask)
- 1.22. Cloud Data Warehouse Integration (Snowflake & IICS) Overview of Snowflake IICS Connecting & implementing SDC with Snowflake Exercise #2: Slowly Changing Dimension Type II & III and VI
- 1.33. Administration overview Enabling source control Switch between different organization Create User Roles, User Groups, and Object level permissions Migration Audit logs
- 1.44. Web services and Hierarchical transformations Overview of Web services Usage of web service transformation Hierarchy Parser Transformation Hierarchy Builder Transformation Exercise #3: Create a mapping that uses a web service transformation. Exercise #4: Create a mapping that uses a Hierarchy Parser transformation. Exercise #5: Create a mapping that uses a Hierarchy Builder transformation. Intelligent Structure Discovery
- 1.55. Informatica Cloud Rest API Overview of Rest APIs in Informatica cloud IP Address Filtering Exercise #6: Create a Rest API to run a mapping task
- 1.66. Performance & Tuning Optimization Partitioning rules and Guidelines Pushdown Optimization Optimizing performance of Blocking Transformations: Aggregator Joiner Ranking Sorter Transaction Control Commit & Rollback Enhancing performance with Blocking Transformations Exercise #6: Optimizing Performance
- 1.77. Advanced Topics & Transformations Java Transformation Masking Transformation Exercise #7: Masking Data + Java Data Integration Elastic
Instructor
