Skip to content
ThinkETL

ThinkETL

  • Home
  • Interview Questions
  • Certification
  • Informatica
    • Advanced Concepts
    • Automation
    • Certification
    • Connectors
    • Interview Questions
    • Real-time Scenarios
    • Rest API
    • Secure Agent
    • Slowly Changing Dimensions
    • Taskflows
    • Transformations
  • Snowflake
    • Access Control and Security
    • Data Loading and Handling
    • Data Management and Utilities
    • Query and Performance Optimization
    • Snowflake REST API
    • Snowpark
    • Snowpipe
    • Stored Procedures
  • Catalogue
  • Courses

Advanced Concepts

User Defined Functions in Informatica Cloud

User-Defined Functions (UDFs) in Informatica Cloud (IICS)

November 26, 2023October 8, 2023

User-defined functions allows you to create and store complex transformation logic using built-in functions and reuse them across mappings.

Categories Advanced Concepts, Concepts, Informatica
Mapplets in Informatica Cloud

Mapplets in Informatica Cloud (IICS)

November 26, 2023October 1, 2023

Mapplets are a powerful feature to build reusable transformation logic and use across multiple mappings in Informatica Cloud.

Categories Advanced Concepts, Concepts, Informatica
Pushdown Optimization Preview in Informatica Cloud

Pushdown Optimization Preview in Informatica Cloud (IICS)

November 26, 2023July 14, 2023

Pushdown Optimization Preview helps in identifying the SQL to be executed and issues if any in the mapping that is preventing it from being configured for PDO.

Categories Advanced Concepts, Concepts, Informatica
Dynamic Mapping Task Informatica Cloud

Dynamic Mapping Task in Informatica Cloud (IICS)

November 26, 2023October 2, 2022

A Dynamic Mapping Task lets you create and group multiple jobs based on the data flow logic defined in a parameterized mapping.

Categories Advanced Concepts, Concepts, Informatica
File Processor Connector in IICS

File Processor Connector: Transfer files between SFTP Server and Local System in IICS

November 26, 2023September 10, 2022

File Processor Connector in IICS lets you securely transfer files from one location to another regardless of size and location.

Categories Advanced Concepts, Concepts, Connectors, Informatica
FTP-SFTP CONNECTION

FTP/SFTP connection: Read files from remote server in Informatica Cloud (IICS)

November 26, 2023August 15, 2022

FTP/SFTP Connection in Informatica Cloud enables you to access source and target files present in a remote sever.

Categories Advanced Concepts, Concepts, Connectors, Informatica
Indirect loading of AWS S3 files

Indirect loading of AWS S3 files using Informatica Cloud (IICS)

November 26, 2023July 11, 2021

Learn how to read multiple files from Amazon S3 and write to single target in IICS using manifest file through Indirect Loading method.

Categories Advanced Concepts, Concepts, Informatica
Flow Run Order in IICS

Flow Run Order: Target Load Plan in Informatica Cloud (IICS)

November 26, 2023February 24, 2021

Learn how to configure Flow Run Order in IICS to specify the order in which data Integration service process the data flows in a mapping

Categories Advanced Concepts, Concepts, Informatica
Partitioning Overview in IICS

Overview of Partitioning in Informatica Cloud (IICS)

November 26, 2023February 20, 2021

Complete overview of Partitioning in Informatica Cloud Data Integration and comparison with Powercenter partitioning.

Categories Advanced Concepts, Concepts, Informatica
Pushdown Optimization

Pushdown Optimization in Informatica Cloud (IICS)

November 26, 2023February 10, 2021

A complete overview of Pushdown Optimization performance tuning technique types, limitations and advanced options in Informatica Cloud.

Categories Advanced Concepts, Concepts, Informatica
Older posts
Page1 Page2 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

  • Data Unloading using COPY INTO Command in Snowflake
    Data Unloading using COPY INTO Command in Snowflake
  • Snowflake Directory Tables
    Snowflake Directory Tables: Query and Manage Staged Files
  • Snowflake File URLs Securely Access & Share Staged Files
    Snowflake File URLs: Securely Access and Share Staged Files
  • Data Load using COPY INTO Command in Snowflake
    Data Load using COPY INTO Command in Snowflake
  • Executing External API calls from Snowflake
    HOW TO: Make External API calls from Snowflake?

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
  • Courses
  • Privacy Policy
  • Subscribe
  • Terms of Use
  • Automation
  • Certification
  • Concepts
  • Informatica
  • Interview Questions
  • Snowflake

Follow Us

Copyright © 2023 ThinkETL