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)
- 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: 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)
- 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
Informatica Cloud Connectors
- 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: 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 Slowly Changing Dimensions
- HOW TO: Implement SCD Type-1 Mapping in Informatica Cloud (IICS)
- HOW TO: Implement SCD Type-2 Mapping in Informatica Cloud (IICS)
- HOW TO: Implement SCD Type-2 using Dynamic Lookup in Informatica Cloud (IICS)
- HOW TO: Implement SCD Type-3 Mapping in Informatica Cloud (IICS)
- HOW TO: Implement SCD Type-6 Mapping in Informatica Cloud (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
Informatica Cloud Certification
- Informatica Cloud Data Integration Free Tutorial Registration Guide
- Informatica Cloud (IICS) Professional Certification-Registration Guide
- Informatica Cloud Certification Sample Test
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
Getting Started and Overview
Access Control and Security
- 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?
Data Loading and Handling
- 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?
Data Management and Utilities
- Overview of Snowflake Time Travel
- Snowflake Zero Copy Cloning
- Snowflake Information Schema
- Snowflake Resource Monitors
- Snowflake Virtual Warehouses
- Snowflake Tasks: Execute SQL Statements on Schedule
- 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?
- Change Data Capture using Snowflake Streams
Data Ingestion and Streaming
- Introduction to Snowpipe on Azure
- Introduction to Snowflake Snowpipe on AWS
- Continuous Data Loading and Monitoring using Snowpipe
- Snowflake Snowpipe REST API
Query and Performance Optimization
Snowflake SQL REST API
- Introduction to Snowflake SQL REST API using Postman
- Execute multiple SQL statements in a single Snowflake API request
- Snowflake Snowpipe REST API
Functions and Stored Procedures
Certification and Interview Preparation
SQL (Structured Query Language)
Didn't find what you are looking for?
Write to us and we will include them in our future posts !!