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)
Date Functions in SQL
Select Getdate() as CurrentDate; Select Getdate() -1 PreviousDate; Select Getdate() +1 NextDate; Select DATEADD(dd,1,getdate()) as NextDate;...
-
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....
-
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...
No comments:
Post a Comment