Skip to content
ThinkETL

ThinkETL

  • Home
  • Automation
  • Interview Questions
  • Concepts
  • Certification
  • Catalogue
interview questions -1

Top Informatica Cloud (IICS) Interview questions

January 26, 2023September 26, 2020

A complete collection of top Informatica Cloud(IICS) interview questions

Categories Interview Questions

How to read metadata in Informatica Cloud (IICS)?

September 18, 2022September 23, 2020

Ultimate guide to understand how to read metadata in Informatica Cloud

Categories Automation
EXCEPTIONS in Snowflake Stored Procedures

Exceptions in Snowflake Stored Procedures

March 25, 2023

Snowflake allows catching exceptions and their error information that occur in stored procedures by defining exceptions.

Categories Concepts
RESULTSET in Snowflake Stored Procedures

RESULTSET in Snowflake Stored Procedures

March 13, 2023

Snowflake allows storing the result set of a SELECT statement and return them as output in the form a table using RESULTSET.

Categories Concepts
Cursors in Snowflake Stored Procedures

Cursors in Snowflake Stored Procedures

March 6, 2023

Cursors allows you to loop through a set of rows of a query result set and perform same set of defined actions for each row individually.

Categories Concepts
Looping in Snowflake Stored Procedures

Looping in Snowflake Stored Procedures

March 3, 2023February 28, 2023

Loops in Snowflake Stored Procedures enables you to execute a set of statements until a particular condition is satisfied.

Categories Concepts
IF ELSE, CASE Statements in Snowflake Stored Procedures

IF-ELSE, CASE Statements in Snowflake Stored Procedures

March 1, 2023February 26, 2023

IF ELSE, CASE statements in Snowflake Stored Procedures provides a way to execute a set of statements if a condition is met.

Categories Concepts
EXECUTE IMMEDIATE in Snowflake Stored Procedures

EXECUTE IMMEDIATE in Snowflake Stored Procedures

February 27, 2023February 22, 2023

EXECUTE IMMEDIATE command in Snowflake executes SQL statements present in form a character string and returns the result.

Categories Concepts
Variables in Snowflake Stored Procedures

Variables in Snowflake Stored Procedure

February 21, 2023February 21, 2023

A Variable is a named object which holds a value of a specific data type whose value can change during the stored procedure execution.

Categories Concepts
Introduction to Snowflake Stored Procedures

Introduction to Snowflake Stored Procedures

February 21, 2023February 13, 2023

Stored procedures allow you to write procedural code that executes business logic by combining multiple SQL statements.

Categories Concepts
Row-Level Security using Row Access Policies in Snowflake

Row-Level Security using Row Access Policies in Snowflake

March 2, 2023February 9, 2023

A Row Access Policy is a schema-level object that is assigned to a table or view and determines whether a given row in them can be viewed by a user.

Categories Concepts
Row-Level Security using Secure views in Snowflake

Row-Level Security using Secure Views in Snowflake

March 2, 2023February 5, 2023

Row-Level Security is a security mechanism that limits the records returned from a database table based on the permissions provided to the currently logged-in user.

Categories Concepts
Older posts
Page1 Page2 … Page12 Next →

Take up the Quiz

  • IICS Interview Questions Quiz-1
  • IICS Interview Questions Quiz-2
  • IICS Interview Questions Quiz-3
  • IICS Interview Questions Quiz-4
  • IICS Transformations Quiz-1
  • IICS Transformations Quiz-2
  • IICS Taskflows Quiz
  • IICS Expression Macros Quiz
  • IICS Certification Practice Test
  • SQL Analytic Functions Quiz
Informatica Cloud Professional Certification Practice Tests
Deal extended: Courses Up To 85% Off

Subscribe

Informatica Cloud Data Integration - Automation Project

Recent Posts

  • EXCEPTIONS in Snowflake Stored Procedures
    Exceptions in Snowflake Stored Procedures
  • RESULTSET in Snowflake Stored Procedures
    RESULTSET in Snowflake Stored Procedures
  • Cursors in Snowflake Stored Procedures
    Cursors in Snowflake Stored Procedures
  • Looping in Snowflake Stored Procedures
    Looping in Snowflake Stored Procedures
  • IF ELSE, CASE Statements in Snowflake Stored Procedures
    IF-ELSE, CASE Statements in Snowflake Stored Procedures

About ThinkETL

ThinkETL is your go to resource for learning Informatica Cloud and Snowflake Concepts, Interview preparation and Automation Ideas and strategies that work.

Pages

  • About
  • Catalogue
  • Certification
  • Contact
  • Privacy Policy
  • Subscribe
  • Terms of Use

Categories

  • Automation
  • Certification
  • Concepts
  • Interview Questions

Follow Us

Copyright © 2023 ThinkETL