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

Real-time Scenarios

Parameterizing Expression Transformation in Informatica Cloud

HOW TO: Parameterize Expression Transformation in Informatica Cloud (IICS) ?

July 13, 2024

Expression transformations can be fully parameterized in Informatica Cloud mappings, allowing fields to be created at the mapping task level.

Categories Informatica, Real-time Scenarios
Add Filename field for S3 Flat Files in Informatica Cloud

HOW TO: Add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in IICS?

November 26, 2023September 13, 2023

Learn how to add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in Informatica Cloud.

Categories Concepts, Informatica, Real-time Scenarios
Excel Connector in IICS

HOW TO: Read Excel Files in Informatica Cloud (IICS)?

November 26, 2023September 11, 2022

Microsoft Excel Connector is an Add-On Connector that let you read data from multiple worksheets of an Excel source file.

Categories Concepts, Connectors, Informatica, Real-time Scenarios
Informatica Cloud Debugger

HOW TO: Use Informatica Cloud (IICS) Debugger

November 26, 2023August 4, 2022

Informatica Cloud Debugger helps you preview data to troubleshoot errors at any point in a mapping, even as you build it.

Categories Concepts, Informatica, Real-time Scenarios
Reading Json files from AWS s3

HOW TO: Read JSON files from AWS S3 in Informatica Cloud (IICS)?

November 26, 2023October 8, 2021

The process to read JSON files from AWS S3 using IICS is different reading from Secure agent machine. Learn how to read JSON files from AWS S3 using different methods.

Categories Concepts, Informatica, Real-time Scenarios
Decimal Precision Loss in IICS

HOW TO: Resolve Decimal Precision Loss in Informatica Cloud (IICS)?

November 26, 2023September 24, 2021

When Enable High Precision property should be enabled and how it resolves the decimal precision loss or rounding issue in Informatica Cloud

Categories Concepts, Informatica, Real-time Scenarios
Parameterizing Connections

HOW TO: Parameterize Source and Target Connections in Informatica Cloud (IICS)?

November 26, 2023May 10, 2021

The connections in IICS CDI can be parameterized at mapping level which needs to be resolved at MCT level. But you can override the values at MCT level using parameter file.

Categories Concepts, Informatica, Real-time Scenarios
Passing Values from one Task to another in CDI

HOW TO: Pass data from one Mapping Task to another in Informatica Cloud (IICS)?

November 26, 2023May 9, 2021

Informatica Cloud supports passing data from one Mapping Task to another. The data can be passed through a Task flow using IO parameters.

Categories Concepts, Informatica, Real-time Scenarios
Daylight-Saving-Changes-IICS

HOW TO: Handle Daylight Saving Time changes in Informatica Cloud (IICS)

November 26, 2023January 27, 2021

Learn how to calculate daylight saving time start and end dates in a given year in Informatica Cloud along with common issue with DST and how to solve them.

Categories Concepts, Informatica, Real-time Scenarios
runAJob utility

How to trigger IICS Tasks from Command Line using RunAJob Utility?

November 26, 2023January 10, 2021

Understand how to trigger IICS tasks from command line using RunAJob utility and its requirements and setup process.

Categories Concepts, Informatica, Real-time Scenarios
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