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...
-
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...
-
Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
No comments:
Post a Comment