Top Informatica Cloud Courses in Udemy
A curated list of top Informatica Cloud courses available on Udemy covering various Informatica Service offerings.
Top Informatica Cloud (IICS) Interview questions
A complete collection of top Informatica Cloud(IICS) interview questions
How to read metadata in Informatica Cloud (IICS)?
Ultimate guide to understand how to read metadata in Informatica Cloud
RESULT_SCAN in Snowflake
RESULT_SCAN in Snowflake retrieves the results of a previously executed query and presents them as a virtual table allowing to run subsequent queries
HOW TO: Delete Rows From a DataFrame in Snowflake Snowpark?
Discover how to delete rows from a DataFrame in Snowpark using Table.update() and Session.sql() methods.
Introduction to Snowflake Notebooks
Snowflake Notebooks provide an interactive environment to write, execute, and document SQL and Python code in one interface.
HOW TO: Merge two DataFrames in Snowflake Snowpark?
Table.merge() method in Snowpark allows merging the contents of a Snowpark table object with a DataFrame source based on a specified join condition.
HOW TO: Execute SQL Statements in Snowflake Snowpark?
Snowpark allows direct execution of SQL statements using the session.sql() method in conjunction with collect() method.
DATEADD Function in Snowflake: Add or Subtract Time Intervals from Dates
DATEADD Function in Snowflake calculates a date or timestamp value by adding a specified interval to a given date or timestamp.
Snowflake Alerts: Schedule Conditional SQL Statements
A Snowflake Alert allows scheduled execution of conditional SQL statements, enabling users to monitor specific events or thresholds within their environment.
HOW TO: Send Email Notification in Snowflake?
Snowflake offers built-in stored procedures SYSTEM$SEND_EMAIL and SYSTEM$SEND_SNOWFLAKE_NOTIFICATION for sending email notifications.
ASOF Join in Snowflake
ASOF JOIN in Snowflake matches each row in one table to the closest row in another table based on a specified condition, typically involving time series data.
MIN_BY and MAX_BY Functions in Snowflake
MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.