Informatica cloud jobs can be run on :
Only on cloud
Only on agent
on cloud and on agent
Full form if iPaas :
Informatica Platform as a service
Integration Platform as a service
Intelligent Platform as a service
Informatica cloud can do real time integration with Salesforce
IICS stands for
Intelligent Integration Cloud Services
Intelligent Informatica Cloud Services
Informatica Intelligent Cloud Services
Informatica Cloud (IICS) have below components
Data Integration
Application Integration
Monitor
Application Integration Console
In Application Intregration console we can develop our code by using Process, Service connector, Connection etc
Monitor is used for monitoring application integration Jobs
We can create below assets in Application Integration
Process
Service Connector
Mapping
Connection
We can create below assets in Data Integration
Mapping configuration
Data Synchronization
Data Replication
Guides
Connection can be created in :
Application Integration only
Administrator only
Both in application integration and administrator
Picture is representing which data set
XML
Json
Neither XML nor json
Attached image represent :
Taskflow
Transformation like expression, aggregator, filter, router are a part of :
Which one of the below statement is correct
Taskflow can be scheduled via scheduler
Process can also be schedule from application integration console
Minimum interval for a Scheduler available in administrator is 2 min
Which of the below statement is incorrect
Multiple mapping can be called/wrapped in single Mapping configuration task
Data synchronization task can be also called in taskflow
Mapping can be called in taskflow
Multiple Mapping configuration task can use same mapping
Which of the following is not a task
Maaping configuration
Mapplet
Nulls are allowed in Primary Key
Foreign Key can have duplicate values
Delete * from <table name> . Is this the correct statement
Below Services are used to keep track of jobs/processes executed
Which Transformation it is ?
Aggreegator
Sorter
Joiner
Router
Under which services you can schedule Data Integration Jobs
Administrator
Screenshot depicts _________________________________________________
Data Replication task
A table has data which store the marks of a student. Which kind of table it is
Fact
Dimension
OLAP stands for
On Line Analytical Program
On Line Analytical Processing
On Line Analytical Process
On Line Analytical publsihing
Which Transformation ?
Aggregator
Normalizer
Hierarchy Parser
Hierarchy builder
Scenario: Source is a Flat file which has duplicate records. We need to populate distinct records into the target. Which Transformation can be used to achieve it
Expresession
Which type of slowly changing dimension it is
SCD Type 1
SCD Type 2
SCD Type 3
SCD Type 6
Which out of below are falls under category of an iPaas tool
Dell Boomi
Talend
Mulesoft
Informatica cloud
A Data Warehousing (DW) is process for collecting and managing data from varied sources to provide meaningful business insights