1) You are required to build a mapping that will combine data from two different tables with the same structure. Which transformation would you use to achieve this?

2) You need to load data from multiple sources into a single target table, applying different transformation rules for each source. Which transformation allows you to route data based on conditions?

3) To generate unique keys for each row processed in a mapping, which transformation would you include?

4) You have a use case where you need to aggregate data by grouping it based on a column, such as Region. Which transformation should you use in your mapping?

5) A data integration project requires capturing CDC (Change Data Capture) data from a database and loading it to a data lake. Which IICS service would you use?

6) You need to join two datasets in IICS where one dataset is small and frequently referenced by other datasets. Which transformation would be optimal for this purpose?

7) In a project where you need to perform row-level transformations based on a series of complex calculations, which transformation would be most suitable?

8) Your project involves extracting data from a source system with schema drift. Which IICS feature is well-suited to handling changing schemas?

9) You are building an ETL process that involves conditional branching to load data into different target tables based on data values. Which transformation would you use?

10) You need to set up a job to run an ETL task daily at 2:00 AM. Which IICS tool would you use to automate this?

11) To handle a project requirement for real-time data synchronization from a streaming source, which IICS task type should you choose?

12) You have to create a mapping that checks if a column value exists in another table and retrieves additional data if it does. Which transformation would you use?

13) To meet a project requirement, you need to split data into multiple targets based on specific business rules. Which IICS transformation will allow you to route data conditionally?

14) You are tasked with scheduling multiple mappings to run one after another. Which feature in IICS would you use to create this sequence?

15) For a project requirement, you need to aggregate data to calculate average sales per region. Which transformation should you use?

16) A project needs data from a cloud source to be synchronized with a local database. Which IICS task is suitable for this ongoing synchronization?

17) You are tasked with building a reusable component to check data quality rules. What feature in IICS allows you to build reusable mappings?

18) To enable fault-tolerant data processing with failover support, which IICS feature would you enable on the Secure Agent?

19) A requirement calls for loading only updated rows from a source table into the target. Which transformation would help you implement this in IICS?

20) A project requires you to use multiple Secure Agents in different regions for high availability. Which IICS feature facilitates this configuration?