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

• 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 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?
  

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

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?
  

SQL (Structured Query Language)

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