move data from one table to another performing transformation like change datatype,column name etc within datawarehouse
move data from one database table to another database table (both database can be in differnt server)
change dataTypes and column name
Multicast: Multicast Transformation allows you to send input data to multiple outputs. It creates copies of the data and sends it to different destinations