Home

Informatica Cloud IICS Interview Questions Set-02

Replication Task Interview questions:

What is Replication Task in Informatica Cloud IICS?

  • The replication task is used to Copy data from a salesforce or database source to a database or file target.
  • It moves data in large quantities swiftly and efficiently.
  • Normally we use the Replication task to copies the data from source to target. You might replicate data to back up single table or multiple tables from one database to another database.

What are the Database types that Replication task supports?

Replication Task only support FF (Flat File), SFDC(Sales Force) and relational Databases like Oracle, SQL Server and MySQL. But it will not support Cloud databases like snowflake or GCP.

How many ways you can replicate the objects In Replication Task?

You can Replicate the objects in three ways like All objects, Include Objects, Exclude objects.

If we are using Salesforce as target connection, what kind of operations we will see in Replication task?

You can choose from three different type of operations when you replicate data to a target (Salesforce only).

  • Incremental load after initial full load
  • Incremental load after initial partial load
  • Full load each run

Can we Create custom Relationships and User defined Joins in Replication Task?

No.

Can we use Truncate Target in Replication Task?

No.

Can we use Bulk load in Replication Task?

Yes.

Can we use Data filters in Replication Task?

Yes.

Can we use database tables, aliases, and views as sources in Replication Task?

Yes.

Can we configure a replication task when the source and target object are the same?

No.

Can we Add Mapplets in Replication Task?

No.

Difference between Synchronization task and Replication task?

Data Transfer Task Interview questions:

What is Data Transfer Task in Informatica Cloud IICS?

  • We will use Data Transfer task to Transfer the data from source to target with simple filters.
  • Mainly used to transfer the data from on-premises database to cloud Datawarehouse’s like snowflake.

What are the types of transformation operations that Data Transfer task supports?

When you configure a data transfer task, you can join the source data with data from a second source (lookup source.), based on the source connection that you use. you can also sort and filter the data before you load it to the target.

What are the target operations supported in Data Transfer task?

You can use operations at target level like Insert, Update, Upsert(Update or Insert) , Delete or data driven based on your requirement.

Can we use Truncate Target in Data Transfer task?

Yes.

Can we use Bulk load in Data Transfer Task?

Yes.

What are the advanced source attributes available used in Data Transfer task?

We have the below properties available in data transfer task.

  1. Pre SQL
  2. Post SQL
  3. SQL Override
  4. Schema Name

Can we Add Mapplets in Data Transfer Task?

No.

Leave a comment

Subscribe for material notification

Fill this form to get notify when we post new study materials on Raj Informatica.

Post Notification
Table of Contents

Recent Comments

  • T PUNDALIK 10 November 2023
    Thank you Raj sir nice explanation no one can have this much patience to
  • Sri Lalitha 6 November 2023
    Thank you for sharing your knowledge sir, very helpful to face the interview.
  • jyothi 6 November 2023
    hello sir. thank you for this understanding material like notes
  • ramu 6 November 2023
    good understanding sir
  • veena 6 November 2023
    Hi sir, this notes has clearily explained the what is iics, and difference between
  • durgaashok 6 November 2023
    Good notes and easy
  • Gouda Anusha 6 November 2023
    Hey Sir, I have read all oracle commands and understood very well and its clear
  • srinivas 6 November 2023
    Good content and notes
  • Gouda Anusha 6 November 2023
    Hey Sir, I have read all oracle commands and understood very well and its clear
  • Sravanajyothi 6 November 2023
    Hi Sir, Thank you for all information provided about the Expression transformation which is very
  • Lokesh 6 November 2023
    Good Stuff for Interview preparation process
  • lalitha 5 November 2023
    Hello Raj sir..thank you for your Excellent Training and Motivating every student to get a
Back to Top
Product has been added to your cart

Continue Reading Informatica Cloud IICS Interview Questions Set-02

Fill out this form to explore all our interview question sets.

Question-Popup

Instructor-Led IT Software Training

Get your dream IT job at top MNCs in just 45 days!

Interested to join? fill this form👇🏻 we'll contact you!

Contact Form