IICS CDI Quiz1

The Synchronization Task is designed to map source fields to target fields based on the field mapping configurations you set up in the task. The field mapping is typically defined explicitly, and you can map source fields to target fields even if the names are different. The mapping is based on the logic you set up in the task to determine how data from source fields should be copied or transformed into the corresponding target fields.

IICS stores metadata, configuration, and design elements within a customer's IICS organization, the actual customer data is typically sourced from external systems and stored in the designated destinations specified in the integration workflows

File Listener is used to monitor for certain files in a specified directory. For example you can set the event source inside the taskflow to the file listener and each time file listener will find a specified file a taskflow will be triggered.

An unconnected lookup transformation is a lookup transformation that is not connected to a source or target in the mapping.

In Informatica Intelligent Cloud Services (IICS), it is not possible to directly update an existing IDMC (Informatica Data Integration Service) schedule within a mapping task. The scheduling of tasks and workflows is typically managed in the IICS web interface or through the REST API.

To update an existing schedule, you would generally need to make changes in the IICS web interface by accessing the Schedule tab and modifying the schedule settings for the corresponding task or workflow.

Vertical: A vertical macro expands an expression vertically. The vertical macro generates a set of similar expressions to perform the same calculation on multiple incoming fields.
Horizontal: A horizontal macro expands an expression horizontally. The horizontal macro generates one extended expression that includes a set of fields or constants.
Hybrid: A hybrid macro expands an expression both vertically and horizontally. A hybrid macro generates a set of vertical expressions that also expand horizontally

File Listener in IICS is designed to support various connection types, including Azure Data Lake Store Gen2, Local Folder, Advanced SFTP V2, and Amazon S3 V2. It allows you to configure file listeners to monitor these different types of locations for incoming files and trigger actions based on specified criteria.

Filter: Filters rows from the source based on specified conditions.
Expression: Allows you to perform calculations, apply conditions, and manipulate data using expressions.
Lookup: Retrieves data from a relational table or flat file based on a condition specified in the mapping.

Conversion is not a mapping transformation, in IICS instead of conversion transformation we can use one of the following functions:
TO_BIGINT, TO_CHAR(Number), TO_DATE, TO_DECIMAL, TO_FLOAT, TO_INTEGER

When using the Sorter Transformation in Informatica Intelligent Cloud Services (IICS) with partitioning enabled, the data is sorted within each individual partition, and then the results are combined or merged across all partitions. It does not sort the data through a single partition and then allocate to multiple partitions