Informatica 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)

2. 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

3. Administration overview Enabling source control Switch between different organization Create User Roles, User Groups, and Object level permissions Migration Audit logs

4. 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

5. 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

6. 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