Router transformation is an active and connected transformation. It is an extension of the filter transformation. Here in the router, we can give multiple filter conditions and pass the records that satisfy the filter conditions and route the rest of the records to the default group, whereas in the filter, we can give a single condition that connects to a single target, and records that do not satisfy the condition will be dropped or filtered out at the mapping level.
Subscribe to:
Post Comments (Atom)
Partitioning
Hive organizes the tables into partitions, and partitions are subdivided into buckets. ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION ...
-
Lookup Transformation is both connected and unconnected. Lookup Transformation is both active and passive. From Informatica PowerCenter...
-
IICS provides a list of tasks like mapping task, powercenter tasks, synchronization task, replication task, masking task, dynamic mapping ta...
-
In this SCD Type 2 historical data is maintained along with current data. SCD Type 2 concept can be implemented with 3 different methods. D...
No comments:
Post a Comment