SQL Transformation: Query Mode in Informatica Cloud (IICS)
A SQL Transformation can be used to process a SQL query either using a “Saved Query” or a User “Entered Query”.
A SQL Transformation can be used to process a SQL query either using a “Saved Query” or a User “Entered Query”.
SQL Transformation in Informatica Cloud is used to call a Stored Procedure or Function, or execute SQL queries midstream in a mapping pipeline.
User-defined functions allows you to create and store complex transformation logic using built-in functions and reuse them across mappings.
Mapplets are a powerful feature to build reusable transformation logic and use across multiple mappings in Informatica Cloud.
Learn how to add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in Informatica Cloud.
Advanced Serverless is a fully managed serverless deployment solution with no clusters or software to manage with high-performance and built-in elasticity.
Informatica Cloud Data Integration Elastic (CDI-E) enables you to process your jobs on advanced Spark serverless compute engine.
Snowflake combines best of tagging and data masking features to protect sensitive data which is referred to as Tag-based Data Masking
Tags in Snowflake can be applied on the database objects which lets you discover, monitor and protect sensitive data.
A comprehensive list of all resources that help you in your Snowflake SnowPro Core Certification examination preparation.