Informatica cloud - IICS Interview Questions - CDI & CAI Realtime Interview Questions and Answers

#informaticacloud #iics #interview #interviewquestions #iicstutorial #rajinformatica #informaticaonlinetraining

Raj Cloud Technologies Informatica IICS(IDMC) CDI & CAI Realtime online Training

👉 Join Informatica IICS(IDMC) WhatsApp group: https://chat.whatsapp.com/KlCxKZZNqO7...

Raj Cloud Technologies Informatica Powercenter Realtime online Training
👉 Join Informatica Powercenter WhatsApp group: https://chat.whatsapp.com/CgvimXO3udO...


☎️ Contact: 8105296858
Website : https://rajinformatica.com/informatic...



https://rajinformatica.com/

Informatica IICS Interview Questions and Answers By Raj Informatica .

Informatica cloud - IICS - CDI and CAI Interview questions and answers By Raj Informatica .


IICS informatica interview questions-Part-1 By Raj

1. What is the difference between Informatica PowerCenter and Informatica Cloud?

 Informatica Intelligent Cloud Services is a cloud-based Integration platform(iPaaS).
 IICS helps you integrate, synchronize all data and applications residing on your on-premise
and cloud environments.
 It provides similar functionality as PowerCenter in a better way
and can be accessed via the internet. Hence in IICS, there is no need to install any client applications on the personal computer or server.
 All the supported applications can be accessed from the browser and the tasks can be developed through browser UI.


2. Define Informatica Cloud or IICS?

Informatica Cloud is an ETL and Integration platform providing a web interface to web developers to access administrators and monitor the tasks by using that web interface.
It helps the developers build the solutions that perform the ETL processes between the cloud and on-site solution.

IICS is a cloud-based data integration and management platform. It enables organizations to securely access their data assets. It also allows them to efficiently integrate and manage their data across on-premises, cloud, and hybrid environments.


14. What is a Synchronization Task in Informatica Cloud IICS?

 The synchronization task allows us to synchronize the data between the source and the target to integrate applications, databases and files.
 We can build a synchronization task from the IICS UI by choosing the Source and the target without using any transformations like in mappings.
 Anyone without PowerCenter or IICS mapping and transformation knowledge can easily build synchronization tasks as UI guides you step by step.

15. What are the types of Task operations available in Synchronization Task in Informatica Cloud IICS?

Synchronization task will support Insert, update, Upsert (Update or Insert) and Delete Task operations. To use Update, Upsert or Delete operations, Target table must have a primary key.

37. 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.

38. 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.

39. Can we use Truncate Target in Data Transfer task?
Yes.

40. Can we use Bulk load in Data Transfer Task?
Yes.

41. What are the advanced source attributes available used in Data Transfer task?
We have the below properties available in data transfer task.

 Pre SQL
 Post SQL
 SQL Override
 Schema Name



What is PowerCenter Task in Informatica Cloud IICS?
 We will use PowerCenter task to Import a PowerCenter workflow so you can run it as a Cloud Data Integration task.

 To run a PowerCenter session in Data Integration, you create a workflow for the session in the PowerCenter Workflow Manager. You create a PowerCenter task in IICS. When you
configure the task, you upload the PowerCenter XML file that contains the workflow.

49. Can we make any changes in for a workflow XML file in PowerCenter task in IICS?
No. If you want to make any ch







Informatica interview questions,
Informatica interview questions for experienced,
Sql interview questions,
how to get first record in oracle query,
how to get last record in oracle query,
select last n records from a table in oracle,
what is the difference between union and union all,
difference between union and union all,
difference between union and union all in oracle,

Informatica Intelligent Cloud Services ( IICS ) Interview Questions & Answers