Informatica Cloud
Informatica Cloud Architecture and Secure Agent
- Informatica Cloud (IICS) Architecture
- 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
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
- 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)
- 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?
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
- Top Snowflake Interview Questions
- What is Snowflake?
- Snowflake Architecture
- HOW TO: Create Snowflake Free Trial Account?
- Overview of Snowflake Role Based Access Control
- Snowflake Micro-partitions & Data Clustering
- Snowflake Virtual Warehouses
- Snowflake File Formats
- Types of Snowflake Tables
- Types of Views in Snowflake
- Overview of Snowflake Time Travel
- Snowflake Zero Copy Cloning
- Snowflake Secure Data Sharing
- Snowflake Information Schema
- Snowflake Resource Monitors
- Snowflake Dynamic Data Masking
- 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?
- Introduction to Snowpipe on Azure
- Change Data Capture using Snowflake Streams
- 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?
- Row-Level Security using Secure Views in Snowflake
- Row-Level Security using Row Access Policies in Snowflake
- Key Pair Authentication in Snowflake
- HOW TO: Generate JWT Token for Snowflake Key Pair Authentication?
- Snowflake Stored Procedures
SQL (Structured Query Language)
Didn't find what you are looking for?
Write to us and we will include them in our future posts !!