IDMC - CDI Professional Certification Practice Questions
63 Questions
64 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following Data load types are possible in IICS?

  • Cloud to Cloud
  • Cloud to On-Premise
  • On-Premise to Cloud
  • All of the above (correct)

Informatica Cloud is a cloud based iPaaS solution

True (A)

iPaaS stands for ___

  • Infrastructure Platform as a Service
  • Integration Platform as a Source
  • Integration Platform as a Service (correct)
  • Infrastructure Platform as a Source

IICS can be used for?

<p>All of the above (D)</p> Signup and view all the answers

Which of the following is not a Flat file connection property?

<p>Delimiter (C)</p> Signup and view all the answers

To validate a Salesforce connection, you always need security token

<p>False (B)</p> Signup and view all the answers

Where does the data in tasks and mappings normally get processed?

<p>In the IICS Secure Agent (C)</p> Signup and view all the answers

Secure Agent is ___

<p>a lightweight 64-bit self upgrading program that runs on a machine in the customer's network, or on Amazon, Azure or Google, or hosted by Informatica Cloud (B)</p> 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?

<p>True (A)</p> 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.

<p>False (B)</p> Signup and view all the answers

Which of the following task operations is not supported for a Flat File target in Synchronization task?

<p>Upsert (D)</p> Signup and view all the answers

You cannot run multiple instances of a synchronization task simultaneously.

<p>True (A)</p> Signup and view all the answers

A Synchronization task can be used to delete records.

<p>True (A)</p> Signup and view all the answers

What does the field selection criteria - 'All Fields' do?

<p>Includes or Excludes all fields (A)</p> Signup and view all the answers

To include all incoming fields from an upstream transformation except those with dates, what should you do?

<p>Configure two field rules. First, use the All Fields rule to include all fields. Then, create a Fields by Datatype rule to exclude fields by data type and select Date/Time as the data type to exclude (B)</p> Signup and view all the answers

A mapping with a single transformation that is not connected to another downstream object

<p>is invalid and cannot be run (C)</p> Signup and view all the answers

Which of the following can be used to write to multiple types of targets?

<p>Cloud Mappings (A)</p> Signup and view all the answers

How does a mapping differ from a Synchronization Task?

<p>A mapping can read from multiple types of source objects in a single task (D)</p> Signup and view all the answers

The Cloud Mapping Designer permits a single mapping to have more than one target.

<p>True (A)</p> Signup and view all the answers

Each Mapplet transformation can contain ____

<p>one mapplet (B)</p> Signup and view all the answers

You can call connected Lookup in a :LKP expression

<p>False (B)</p> Signup and view all the answers

A mapplet is a resuable transformation logic

<p>True (A)</p> 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?

<p>Aggregator (B)</p> Signup and view all the answers

All mappings created within the Cloud Mapping Designer must have atleast one parameter

<p>False (B)</p> Signup and view all the answers

Which of the following is a possible reason why a parameter file might cause a mapping to fail?

<p>The parameter file name was changed (B)</p> Signup and view all the answers

A conversion function is necessary when a non-string value is used in a parameter file

<p>True (A)</p> Signup and view all the answers

What is the purpose of the Field Mapping in the Cloud Mapping Designer in the Target transformation?

<p>Allows fields from source to be mapped to the fields in the target (B)</p> 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?

<p>The changes were not saved (C)</p> Signup and view all the answers

Which of the following lookup properties cannot be parameterized

<p>Lookup type(single or multi-return) (C)</p> Signup and view all the answers

Which of the following types of macro cannot be created in IICS?

<p>Declarative Macro (A)</p> Signup and view all the answers

Timestamps can be added as part of flatfile name

<p>True (A)</p> Signup and view all the answers

You cannot simultaneously run multiple Data Replication tasks that write to same target table

<p>True (A)</p> 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?

<p>Informatica Cloud uses one API call per lookup which is expensive and slows the process down. To increase performance, create a Data Replication task that extracts the Salesforce ID and the lookup value (Name for example and the Salesforce ID for that record) into a file or database table and use this in lookup function (D)</p> Signup and view all the answers

When using data masking task, the target object may contain more fields than source.

<p>True (A)</p> Signup and view all the answers

What determines which data masking rules are available?

<p>Datatype (D)</p> Signup and view all the answers

You can use a Taskflow to pass parameters to a task

<p>True (A)</p> Signup and view all the answers

Which of the following cannot be a part of Linear Taskflow?

<p>Schedule Task (A)</p> Signup and view all the answers

IICS validates the SQL during the design time

<p>False (B)</p> Signup and view all the answers

Which of the following is not one of the use cases for Lookup SQL Override?

<p>Changing the lookup data in lookup source (A)</p> Signup and view all the answers

Which of the following is not one of the type of XML Payload messages?

<p>JSON (B)</p> Signup and view all the answers

Hierarchy Parser and Hierarchy Builder transformations can be used without Hierarchal Schema

<p>False (B)</p> Signup and view all the answers

Parameterized mapping tasks can be modified using the IICS REST API

<p>True (A)</p> Signup and view all the answers

Which of the following are benefits of IICS REST API ?

<p>All of the above (D)</p> Signup and view all the answers

Fatal exceptions result in the stopping of the session

<p>True (A)</p> Signup and view all the answers

When running tasks in IICS, which of the following error types could be encountered?

<p>All of the above (D)</p> 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

<p>True (A)</p> Signup and view all the answers

What types of ELT Optimizations are supported in IICS?

<p>All of the above (D)</p> Signup and view all the answers

All connections support Partitioning in IICS

<p>False (B)</p> Signup and view all the answers

Can a user start a task during a Schedule Blackout Period?

<p>Yes, if done manually (B)</p> Signup and view all the answers

If the permission is not configured for an asset, then the asset cannot be used

<p>False (B)</p> Signup and view all the answers

Which of the following asset types can be migrated to a different IICS Organization?

<p>All of the above (D)</p> Signup and view all the answers

Which of the following target operations are available in Data Transfer Task for the users to select?

<p>All of the above (D)</p> 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.

<p>True (A)</p> Signup and view all the answers

Only a single object can be configured as a target in the Data Transfer Task.

<p>True (A)</p> 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 ?

<p>File Ingestion tasks (C)</p> Signup and view all the answers

To trigger taskflow based on file event, you have to define the Binding type as ____

<p>Event (C)</p> Signup and view all the answers

A File Listener component in Informatica Cloud listens to file events on a defined location and file pattern.

<p>True (A)</p> 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.

<p>True (A)</p> 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

<p>Default and Global (C)</p> Signup and view all the answers

Which of the following properties of a Job cannot be configured in a Dynamic Mapping Task?

<p>Parameter File (B)</p> Signup and view all the answers

Intelligent structure model in mappings can be used to parse which of the following types of data?

<p>All of the above (D)</p> Signup and view all the answers

After Intelligent Structure Discovery discovers the structure of the model input, the user can:

<p>All of the above (D)</p> Signup and view all the answers

In which of the following tabs, Intelligent structure model displays the output in a tree-like structure?

<p>Visual Model (A)</p> Signup and view all the answers

Flashcards

IICS Data Load Types

Possible data loading methods in Informatica Cloud Integration Cloud Service (IICS).

Informatica Cloud iPaaS

Cloud-based integration platform as a service (iPaaS) for connecting different systems.

iPaaS

Integration Platform as a Service; a cloud-based platform for connecting different systems.

IICS Use Cases

Possible functionalities of Informatica Cloud Integration Cloud Services, including data integration, data migration, and data warehousing.

Signup and view all the flashcards

Flat File Connection Property

Properties specific to connecting to flat-file sources in IICS, not including delimiters

Signup and view all the flashcards

Salesforce Connection Validation

Verifying the connection to Salesforce, does not always require a security token

Signup and view all the flashcards

Task/Mapping Data Processing

Location where data in tasks and mappings is processed within IICS.

Signup and view all the flashcards

Secure Agent

IICS component that processes tasks on a customer's machine or a cloud environment.

Signup and view all the flashcards

Simple Filter (Data Loading)

A filter that can work on Account records loaded to Salesforce, using criteria for specific data.

Signup and view all the flashcards

Field Expression Syntax (Flat Files)

SQL-like syntax for data manipulation, usable for flat files in IICS.

Signup and view all the flashcards

Flat File Target (Synchronization)

Unsupported operation for flat file target in synchronization tasks.

Signup and view all the flashcards

Simultaneous Synchronization Tasks

Running multiple tasks at the same time is not possible for IICS synchronization tasks.

Signup and view all the flashcards

Synchronization Task and Deletion

Synchronization tasks support deleting records, as a feature of IICS.

Signup and view all the flashcards

Field Selection Criteria ('All Fields')

Selecting all incoming fields in IICS; this may include or exclude all fields in the task

Signup and view all the flashcards

Excluding Date Fields

Two field rules are recommended for excluding fields of a particular datatype in IICS, to manage date exclusion

Signup and view all the flashcards

Standalone Mapping

A mapping without a downstream connection is invalid and cannot be run in IICS.

Signup and view all the flashcards

Multiple Target Mappings

Single mapping can write to multiple types of targets.

Signup and view all the flashcards

Mapping vs. Synchronization Task

Mappings involve multiple sources, whereas a synchronization task deals with a single source and target.

Signup and view all the flashcards

Single Target Cloud Mapping

Allowing more than one target in a single Cloud Mapping.

Signup and view all the flashcards

Mapplet Contents

Individual Mapplet transformations can contain one mapplet transformation within it.

Signup and view all the flashcards

Connected Lookup in :LKP

Can't use connected lookups within IICS :LKP expressions.

Signup and view all the flashcards

Mapplet Reusability

A mapplet is reusable transformation logic within IICS.

Signup and view all the flashcards

Aggregator Transformation

For calculations such as total sales and average deal size per region.

Signup and view all the flashcards

Mapping Parameters

Mapping in IICS does not require parameters to be present.

Signup and view all the flashcards

Parameter File Failure

Problems with parameter files can cause mapping failures due to name changes or inconsistent file content.

Signup and view all the flashcards

Conversion Function (Parameter Files)

Required when using parameter files that contain non-string values.

Signup and view all the flashcards

Field Mapping (Target)

Aligning source and target fields for data transformations and loading in mappings.

Signup and view all the flashcards

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.

Quiz Team

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser