Podcast
Questions and Answers
Which of the following Data load types are possible in IICS?
Which of the following Data load types are possible in IICS?
Informatica Cloud is a cloud based iPaaS solution
Informatica Cloud is a cloud based iPaaS solution
True
iPaaS stands for ___
iPaaS stands for ___
IICS can be used for?
IICS can be used for?
Signup and view all the answers
Which of the following is not a Flat file connection property?
Which of the following is not a Flat file connection property?
Signup and view all the answers
To validate a Salesforce connection, you always need security token
To validate a Salesforce connection, you always need security token
Signup and view all the answers
Where does the data in tasks and mappings normally get processed?
Where does the data in tasks and mappings normally get processed?
Signup and view all the answers
Secure Agent is ___
Secure Agent is ___
Signup and view all the answers
You want to load Account records to Salesforce from a .csv source file where 'BillingState'=NY and 'Annual_Revenue'>10000000. Will a simple filter work?
You want to load Account records to Salesforce from a .csv source file where 'BillingState'=NY and 'Annual_Revenue'>10000000. Will a simple filter work?
Signup and view all the answers
As the field expression syntax is based on database SQL, it cannot be used on data read from a flat-file source.
As the field expression syntax is based on database SQL, it cannot be used on data read from a flat-file source.
Signup and view all the answers
Which of the following task operations is not supported for a Flat File target in Synchronization task?
Which of the following task operations is not supported for a Flat File target in Synchronization task?
Signup and view all the answers
You cannot run multiple instances of a synchronization task simultaneously.
You cannot run multiple instances of a synchronization task simultaneously.
Signup and view all the answers
A Synchronization task can be used to delete records.
A Synchronization task can be used to delete records.
Signup and view all the answers
What does the field selection criteria - 'All Fields' do?
What does the field selection criteria - 'All Fields' do?
Signup and view all the answers
To include all incoming fields from an upstream transformation except those with dates, what should you do?
To include all incoming fields from an upstream transformation except those with dates, what should you do?
Signup and view all the answers
A mapping with a single transformation that is not connected to another downstream object
A mapping with a single transformation that is not connected to another downstream object
Signup and view all the answers
Which of the following can be used to write to multiple types of targets?
Which of the following can be used to write to multiple types of targets?
Signup and view all the answers
How does a mapping differ from a Synchronization Task?
How does a mapping differ from a Synchronization Task?
Signup and view all the answers
The Cloud Mapping Designer permits a single mapping to have more than one target.
The Cloud Mapping Designer permits a single mapping to have more than one target.
Signup and view all the answers
Each Mapplet transformation can contain ____
Each Mapplet transformation can contain ____
Signup and view all the answers
You can call connected Lookup in a :LKP expression
You can call connected Lookup in a :LKP expression
Signup and view all the answers
A mapplet is a resuable transformation logic
A mapplet is a resuable transformation logic
Signup and view all the answers
Jennifer is working on creating a report. She has sales data for all regions. She would like to determine total sales per region. She would also like to get the average deal size per region. Which transformation should she be using?
Jennifer is working on creating a report. She has sales data for all regions. She would like to determine total sales per region. She would also like to get the average deal size per region. Which transformation should she be using?
Signup and view all the answers
All mappings created within the Cloud Mapping Designer must have atleast one parameter
All mappings created within the Cloud Mapping Designer must have atleast one parameter
Signup and view all the answers
Which of the following is a possible reason why a parameter file might cause a mapping to fail?
Which of the following is a possible reason why a parameter file might cause a mapping to fail?
Signup and view all the answers
A conversion function is necessary when a non-string value is used in a parameter file
A conversion function is necessary when a non-string value is used in a parameter file
Signup and view all the answers
What is the purpose of the Field Mapping in the Cloud Mapping Designer in the Target transformation?
What is the purpose of the Field Mapping in the Cloud Mapping Designer in the Target transformation?
Signup and view all the answers
You have edited(updated) a mapping and the mapping ran but your changes did not take effect. What is the possible reason?
You have edited(updated) a mapping and the mapping ran but your changes did not take effect. What is the possible reason?
Signup and view all the answers
Which of the following lookup properties cannot be parameterized
Which of the following lookup properties cannot be parameterized
Signup and view all the answers
Which of the following types of macro cannot be created in IICS?
Which of the following types of macro cannot be created in IICS?
Signup and view all the answers
Timestamps can be added as part of flatfile name
Timestamps can be added as part of flatfile name
Signup and view all the answers
You cannot simultaneously run multiple Data Replication tasks that write to same target table
You cannot simultaneously run multiple Data Replication tasks that write to same target table
Signup and view all the answers
You have a data synchronization task that is performing a lookup on the Salesforce Account object to return the Salesforce ld and match contacts to their correct Account records, but that task is running very slowly. Why might that be and what can you do to speed up the task?
You have a data synchronization task that is performing a lookup on the Salesforce Account object to return the Salesforce ld and match contacts to their correct Account records, but that task is running very slowly. Why might that be and what can you do to speed up the task?
Signup and view all the answers
When using data masking task, the target object may contain more fields than source.
When using data masking task, the target object may contain more fields than source.
Signup and view all the answers
What determines which data masking rules are available?
What determines which data masking rules are available?
Signup and view all the answers
You can use a Taskflow to pass parameters to a task
You can use a Taskflow to pass parameters to a task
Signup and view all the answers
Which of the following cannot be a part of Linear Taskflow?
Which of the following cannot be a part of Linear Taskflow?
Signup and view all the answers
IICS validates the SQL during the design time
IICS validates the SQL during the design time
Signup and view all the answers
Which of the following is not one of the use cases for Lookup SQL Override?
Which of the following is not one of the use cases for Lookup SQL Override?
Signup and view all the answers
Which of the following is not one of the type of XML Payload messages?
Which of the following is not one of the type of XML Payload messages?
Signup and view all the answers
Hierarchy Parser and Hierarchy Builder transformations can be used without Hierarchal Schema
Hierarchy Parser and Hierarchy Builder transformations can be used without Hierarchal Schema
Signup and view all the answers
Parameterized mapping tasks can be modified using the IICS REST API
Parameterized mapping tasks can be modified using the IICS REST API
Signup and view all the answers
Which of the following are benefits of IICS REST API ?
Which of the following are benefits of IICS REST API ?
Signup and view all the answers
Fatal exceptions result in the stopping of the session
Fatal exceptions result in the stopping of the session
Signup and view all the answers
When running tasks in IICS, which of the following error types could be encountered?
When running tasks in IICS, which of the following error types could be encountered?
Signup and view all the answers
When you create a Secure Agent group, by default, all the users in the organization can select the Secure Agent group as the runtime Environment
When you create a Secure Agent group, by default, all the users in the organization can select the Secure Agent group as the runtime Environment
Signup and view all the answers
What types of ELT Optimizations are supported in IICS?
What types of ELT Optimizations are supported in IICS?
Signup and view all the answers
All connections support Partitioning in IICS
All connections support Partitioning in IICS
Signup and view all the answers
Can a user start a task during a Schedule Blackout Period?
Can a user start a task during a Schedule Blackout Period?
Signup and view all the answers
If the permission is not configured for an asset, then the asset cannot be used
If the permission is not configured for an asset, then the asset cannot be used
Signup and view all the answers
Which of the following asset types can be migrated to a different IICS Organization?
Which of the following asset types can be migrated to a different IICS Organization?
Signup and view all the answers
Which of the following target operations are available in Data Transfer Task for the users to select?
Which of the following target operations are available in Data Transfer Task for the users to select?
Signup and view all the answers
In a Data Transfer Task, it is mandatory to set up one or more lookup conditions when you choose a second source to utilize as a lookup source.
In a Data Transfer Task, it is mandatory to set up one or more lookup conditions when you choose a second source to utilize as a lookup source.
Signup and view all the answers
Only a single object can be configured as a target in the Data Transfer Task.
Only a single object can be configured as a target in the Data Transfer Task.
Signup and view all the answers
A File Listener can be configured to define a file event that triggers notification to which of the following assets ?
A File Listener can be configured to define a file event that triggers notification to which of the following assets ?
Signup and view all the answers
To trigger taskflow based on file event, you have to define the Binding type as ____
To trigger taskflow based on file event, you have to define the Binding type as ____
Signup and view all the answers
A File Listener component in Informatica Cloud listens to file events on a defined location and file pattern.
A File Listener component in Informatica Cloud listens to file events on a defined location and file pattern.
Signup and view all the answers
A Dynamic mapping task reduces the number of assets that you need to manage if you want to reuse a parameterized mapping.
A Dynamic mapping task reduces the number of assets that you need to manage if you want to reuse a parameterized mapping.
Signup and view all the answers
What are the supported options for the parameter scope that can be configured for the mapping parameters in Parameters page of Dynamic Mapping Task wizard
What are the supported options for the parameter scope that can be configured for the mapping parameters in Parameters page of Dynamic Mapping Task wizard
Signup and view all the answers
Which of the following properties of a Job cannot be configured in a Dynamic Mapping Task?
Which of the following properties of a Job cannot be configured in a Dynamic Mapping Task?
Signup and view all the answers
Intelligent structure model in mappings can be used to parse which of the following types of data?
Intelligent structure model in mappings can be used to parse which of the following types of data?
Signup and view all the answers
After Intelligent Structure Discovery discovers the structure of the model input, the user can:
After Intelligent Structure Discovery discovers the structure of the model input, the user can:
Signup and view all the answers
In which of the following tabs, Intelligent structure model displays the output in a tree-like structure?
In which of the following tabs, Intelligent structure model displays the output in a tree-like structure?
Signup and view all the answers
Study Notes
Informatica Cloud (IICS)
- iPaaS stands for Integration Platform as a Service.
- IICS is a cloud-based iPaaS solution.
Data Load Types
- IICS supports various data load types.
Flat File Connections
- 'Record delimiter' is not a Flat File connection property.
- Field expression syntax is based on database SQL, so it cannot be used on data read from a flat-file source.
Tasks and Mappings
- Data in tasks and mappings is normally processed in the Secure Agent.
- A Synchronization task can be used to delete records, but it does not support the 'Update' operation for a Flat File target.
- Multiple instances of a Synchronization task cannot be run simultaneously.
Field Selection Criteria
- The 'All Fields' field selection criteria include all incoming fields from an upstream transformation.
- To include all incoming fields from an upstream transformation except those with dates, use a field selection criteria with a filter.
Mappings and Mapplets
- A mapping with a single transformation that is not connected to another downstream object is called a Mapplet.
- A Mapplet is reusable transformation logic.
- Each Mapplet transformation can contain multiple transformations.
- A connected Lookup can be called in a :LKP expression.
- The Cloud Mapping Designer permits a single mapping to have more than one target.
- Mappings and Synchronization tasks differ in their objectives: mappings focus on data transformation, while Synchronization tasks focus on data movement.
Use Cases
- To load Account records to Salesforce from a .csv source file with specific conditions ('BillingState'=NY and 'Annual_Revenue'>10000000), a filter can be used.
- To determine total sales per region and average deal size per region, an Aggregator transformation should be used.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.