Skip to content
ThinkETL

ThinkETL

  • Home
  • Automation
  • Interview Questions
  • Concepts
  • Certification
  • Catalogue
Dynamic Lookup Transformation

Dynamic Lookup in Informatica Cloud (IICS)

September 18, 2022May 15, 2021

A Dynamic lookup is helpful when you are using the target also as a lookup object in the same mapping and the source data contains duplicate primary keys.

Categories Concepts
Parameterizing Connections

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

December 29, 2022May 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
Passing Values from one Task to another in CDI

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

September 19, 2022May 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
SQL Scenario based Interview Q&A

SQL Scenario based Interview Questions

March 7, 2023May 4, 2021

SQL Scenario based Interview Questions and answers with detailed explanation and results.

Categories Interview Questions
Shared Sequences

Shared Sequences in Informatica Cloud (IICS)

September 18, 2022April 24, 2021

Shared Sequences are reusable sequences that can be used with multiple Sequence Generator transformations in Informatica Cloud.

Categories Concepts
Denormalization in Informatica

HOW TO: Denormalize data in Informatica Cloud (IICS)?

September 18, 2022April 23, 2021

Denormalization is process of converting rows into columns. Understand how to implement the denormalization of data in Informatica Cloud (IICS) mapping and in Oracle using SQL.

Categories Interview Questions
XML vs JSON export in IICS

XML vs JSON export in Informatica Cloud (IICS)

September 18, 2022March 29, 2021

Learn how to export the tasks in in different ways in IICS, the differences in the metadata stored in XML and JSON and how to use it to our advantage.

Categories Automation
Impact Analysis Tool

Informatica Cloud Automation: Building Impact Analysis Tool

September 18, 2022March 23, 2021

A complete guide to building Informatica Cloud Automation tool which automates the process of Impact analysis in IICS.

Categories Automation
Joiner Transformation in IICS

Joiner Transformation in Informatica Cloud (IICS)

September 18, 2022March 18, 2021

Joiner Transformation is used to join data coming from two different data streams based on the condition and the join type defined in Informatica Cloud

Categories Concepts
Normalizer Transformation IICS

Normalizer Transformation in Informatica Cloud (IICS)

September 18, 2022March 18, 2021

Normalizer Transformation transforms one incoming row that contains multiple-occurring data into multiple output rows in Informatica Cloud

Categories Concepts
Older posts
Newer posts
← Previous Page1 … Page10 Page11 Page12 … Page14 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

  • Mapplets in Informatica Cloud
    Mapplets in Informatica Cloud (IICS)
  • 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?
  • Informatica Cloud Advanced Serverless
    Informatica Cloud Advanced Serverless
  • Informatica Cloud Data Integration Elastic
    Informatica Cloud Data Integration Elastic (CDI-E)
  • Tag-based Data Masking in Snowflake
    Tag-based Data Masking in 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
  • Privacy Policy
  • Subscribe
  • Terms of Use

Categories

  • Automation
  • Certification
  • Concepts
  • Interview Questions

Follow Us

Copyright © 2023 ThinkETL