Informatica Cloud

Informatica Cloud Architecture and Secure Agent

• Informatica Cloud (IICS) Architecture
• Informatica Cloud Data Integration Elastic (CDI-E)
• Informatica Cloud Advanced Serverless
• What is Informatica Cloud Secure Agent?
• Secure Agent Groups in Informatica Cloud (IICS)
• HOW TO: Download and Install Informatica Cloud (IICS) Secure Agent?
• HOW TO: Check Secure Agent Status in Informatica Cloud (IICS)?
• HOW TO: Restart Informatica Cloud (IICS) Secure Agent?
• HOW TO: Re-register existing Informatica Cloud Secure Agent to new IICS Org without reinstalling

Informatica Cloud Transformations

• Informatica Cloud Data Integration (IICS) Transformations Guide
• Source Transformation in Informatica Cloud
• Filter Transformation in Informatica Cloud
• Router Transformation in Informatica Cloud
• Expression Transformation in Informatica Cloud
• Sorter Transformation in Informatica Cloud
• Aggregator Transformation in Informatica Cloud
• Sequence Transformation in Informatica Cloud
• Joiner Transformation in Informatica Cloud (IICS)
• Normalizer Transformation in Informatica Cloud (IICS)
• Union Transformation in Informatica Cloud (IICS)
• Lookup Transformation in Informatica Cloud (IICS)
• Dynamic Lookup in Informatica Cloud (IICS)
• Rank Transformation in Informatica Cloud (IICS)
• SQL Transformation: Call Stored Procedures in Informatica Cloud (IICS)
• SQL Transformation: Query Mode in Informatica Cloud (IICS)
• Transaction Control Transformation in Informatica Cloud (IICS)
• Hierarchy Parser Transformation
• Hierarchy Builder Transformation
• WebServices Transformation
• Mapplet Transformation

Informatica Cloud Taskflows

• Overview of Taskflows in Informatica Cloud (IICS)
• Triggering Taskflow based on a File Event using File Listener
• Overriding Parameters, Parameter Files from IICS Taskflows
• Looping in IICS Taskflows using Decision and Jump Steps
• HOW TO: Recover a Suspended Taskflow in Informatica Cloud?
• HOW TO: Schedule a Taskflow in Informatica Cloud?
• HOW TO: Run Informatica Cloud Taskflow as an API?
• HOW TO: Run Informatica Cloud Taskflow with Run Using option?
• HOW TO: Parameterize Taskflows using Parameter Sets in IICS?

Informatica Cloud Advanced Concepts

• Mapplets in Informatica Cloud (IICS)
• Incremental Data Loading in Informatica Cloud (IICS)
• Overview of Partitioning in Informatica Cloud (IICS)
• Partitioning target S3 files in Informatica Cloud (IICS)
• Pushdown Optimization in Informatica Cloud (IICS)
• Pushdown Optimization Preview in Informatica Cloud (IICS)
• Dynamic Mapping Task in Informatica Cloud (IICS)
• Expression Macros in Informatica Cloud (IICS)
• Shared Sequences in Informatica Cloud (IICS)
• Indirect File Loading in Informatica Cloud (IICS)
• Indirect loading of AWS S3 files using Informatica Cloud (IICS)
• User-Defined Functions (UDFs) in Informatica Cloud (IICS)
• Flow Run Order: Target Load Plan in Informatica Cloud (IICS)
• Updating NULL values in Salesforce from Informatica Cloud (IICS)
• Informatica Cloud (IICS) – Salesforce Performance Tuning techniques

• IICS Amazon S3 v2 Connector – Basic Authentication
• IICS Amazon S3 v2 Connector – IAM Authentication
• IICS Amazon S3 v2 Connector – Authenticate via AssumeRole
• IICS Amazon S3 Connection – Temporary Credentials Duration
• Microsoft Excel Connector: Read Excel Files in Informatica Cloud (IICS)
• FTP/SFTP Connector: Read files from remote server in Informatica Cloud (IICS)
• File Processor Connector: Transfer files between SFTP Server and Local System in IICS
• Snowflake Data Cloud Connector: Connect Snowflake from Informatica Cloud (IICS)

Informatica Cloud Real-time Scenarios

• HOW TO: Create JSON file in Informatica Cloud (IICS)?
• HOW TO: Read JSON file in Informatica Cloud (IICS) ?
• HOW TO: Read JSON files from AWS S3 in Informatica Cloud (IICS)?
• HOW TO: Read a Fixed-Width file in Informatica Cloud (IICS)?
• HOW TO: Resolve Decimal Precision Loss in Informatica Cloud (IICS)?
• HOW TO: Configure Email Notifications in Informatica Cloud?
• HOW TO: Handle Daylight Saving Time changes in Informatica Cloud (IICS)
• HOW TO: Parameterize Source and Target Connections in Informatica Cloud (IICS)?
• HOW TO: Parameterize Expression Transformation in Informatica Cloud (IICS) ?
• HOW TO: Pass data from one Mapping Task to another in Informatica Cloud (IICS)?
• HOW TO: Trigger IICS Tasks from Command Line using RunAJob Utility?
• HOW TO: Use Informatica Cloud (IICS) Debugger?
• HOW TO: Add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in IICS?

Informatica Cloud REST API

• Overview of Informatica Cloud (IICS) REST API
• HOW TO: Access Informatica Cloud (IICS) REST API using Postman?
• HOW TO: Access Informatica Cloud (IICS) REST API using REST V2 Connector?
• HOW TO: Access Informatica Cloud (IICS) Rest API from command line using cURL?
• HOW TO: Update Mapping Task in IICS using REST API?
• HOW TO: Create Mapping Task in IICS using REST API?

Informatica Cloud Automation

• How to read metadata in Informatica Cloud (IICS)?
• How to read Mapping Configuration Task metadata in Informatica Cloud (IICS)?
• How to read Mapping metadata in Informatica Cloud (IICS)?
• XML vs JSON export in Informatica Cloud (IICS)
• Informatica Cloud Automation: Building Impact Analysis Tool
• Export & Import tasks in IICS from command line using Asset Management CLI Utility

Informatica Cloud Interview Questions

• Top Informatica Cloud (IICS) Interview questions
• Top Informatica Cloud(IICS) Salesforce Interview questions
• Informatica Cloud (IICS) Scenario based Interview Questions
  • Adding Sequence numbers to the Source records
  • Introducing a dummy field in IICS Mapping
  • Comparing Current record with Previous record
  • LEAD and LAG implementation in Informatica Cloud (IICS)
  • HOW TO: Denormalize data in Informatica Cloud (IICS)?

Informatica Cloud Certification

• Informatica Cloud Data Integration Free Tutorial Registration Guide
• Informatica Cloud (IICS) Professional Certification-Registration Guide
• Informatica Cloud Certification Sample Test
• Top Informatica Cloud Courses in Udemy

Informatica Cloud 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 Expression Macros Quiz
• IICS Taskflows Quiz

Snowflake

• What is Snowflake?
• Snowflake Architecture
• HOW TO: Create Snowflake Free Trial Account?

• Overview of Snowflake Role Based Access Control
• Snowflake Secure Data Sharing
• Snowflake Dynamic Data Masking
• Row-Level Security using Secure Views in Snowflake
• Row-Level Security using Row Access Policies in Snowflake
• Tagging in Snowflake
• Tag-based Data Masking in Snowflake
• Key Pair Authentication in Snowflake
• HOW TO: Generate JWT Token for Snowflake Key Pair Authentication?

• Snowflake Micro-partitions & Data Clustering
• Snowflake File Formats
• Types of Snowflake Tables
• Types of Views in Snowflake
• Types of Snowflake Stages: Data Loading and Unloading Features
• HOW TO: Create External Stages in Snowflake
• HOW TO: Create Snowflake External Tables?
• HOW TO: Load and Query JSON data in Snowflake?
• INSERT and Multi-Table Inserts in Snowflake
• HOW TO: Create Snowflake Iceberg Tables?
• Creating Snowflake Iceberg tables using AWS Glue as Catalog
• Data Load using COPY INTO Command in Snowflake
• Data Unloading using COPY INTO Command in Snowflake
• Snowflake Directory Tables: Query and Manage Staged Files
• Snowflake File URLs: Securely Access and Share Staged Files

• Overview of Snowflake Time Travel
• Snowflake Zero Copy Cloning
• Snowflake Information Schema
• Snowflake Resource Monitors
• Snowflake Virtual Warehouses
• Snowflake SnowSQL: Command Line Tool to access Snowflake
• HOW TO: Remove Duplicates in Snowflake?
• HOW TO: Get DDL of database objects in Snowflake?
• HOW TO: Find and Kill long running queries in Snowflake?
• HOW TO: Send Email Notification in Snowflake?
• Snowflake Alerts: Schedule Conditional SQL Statements
• Snowflake Tasks: Execute SQL Statements on Schedule
• Change Data Capture using Snowflake Streams
• Change Data Capture using Snowflake Dynamic Tables
• Common Table Expressions (CTEs) in Snowflake
• Introduction to Snowflake Notebooks

Snowflake Functions

• GROUP BY ALL Clause in Snowflake
• QUALIFY Clause in Snowflake: Filter Window Functions
• GREATEST and LEAST Functions in Snowflake
• MIN_BY and MAX_BY Functions in Snowflake
• DATEDIFF Function in Snowflake
• DATEADD Function in Snowflake
• ASOF JOIN in Snowflake
• RESULT_SCAN in Snowflake

• Introduction to Snowpipe on Azure
• Introduction to Snowflake Snowpipe on AWS
• Continuous Data Loading and Monitoring using Snowpipe
• Snowflake Snowpipe REST API

• Caching in Snowflake
• Query Acceleration Service in Snowflake
• Search Optimization Service in Snowflake

• Introduction to Snowflake SQL REST API using Postman
• Execute multiple SQL statements in a single Snowflake API request
• Snowflake Snowpipe REST API

• Snowflake User-Defined Functions (UDFs)
• Snowflake Stored Procedures
  • Chapter-1: Create Procedure
  • Chapter-2: Variables
  • Chapter-3: EXECUTE IMMEDIATE
  • Chapter-4: IF-ELSE, CASE Branching Constructs
  • Chapter-5: Looping in Stored Procedures
  • Chapter-6: Cursors
  • Chapter-7: RESULTSET
  • Chapter-8: Exceptions
  • Chapter-9: Caller’s and Owner’s Rights in Snowflake Stored Procedures
  • Chapter-10: Make External API calls using Snowflake Stored Procedures

SQL (Structured Query Language)

• SQL Scenario based Interview Questions
• SQL Analytical Functions Interview Questions
• Top Advanced SQL Interview Questions
• SQL Analytic Functions Quiz