Friday, December 13, 2024

List of tasks in IICS

IICS provides a list of tasks like mapping task, powercenter tasks, synchronization task, replication task, masking task, dynamic mapping tasks, and data transfer tasks.

MAPPING TASK: This task is similar to the informatica session task












SYNCHRONIZATION TASK: This task is used to synchronize data from source to target.

- It is used for Analytical purpose or Business Intelligence purposes.
- Full or incremental data replication can be done from source to target.













REPLICATION TASK: This task is used to replicate or copy the data from source to target

- Insert, update, delete, and upsert can be implemented here.













DYNAMIC TASK: This task is used when there are multiple sources and targets and we want to run them with a single mapping.











POWER CENTER TASK: This task is used to import Xml files from PowerCenter to IICS






No comments:

Post a Comment

Partitioning

Hive organizes the tables into partitions, and partitions are subdivided into buckets. ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION ...