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)
Window Functions in SQL
Window functions perform calculations across a set of rows related to the current row without collapsing the rows into a single result. Unli...
-
Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
-
Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...
-
The functions SUM, COUNT, AVG, MIN, MAX are the common aggregate functions the result of which does not depend on the order of the records....
No comments:
Post a Comment