...
How does the tool handle the SCD TYPE 2 (hISTORY) where it has to TAKE CARE OF insert/update strategy? Does it has any transformation...?
Again, it's handled automatically by the "Dimension Lookup/Update" step:
http://wiki.pentaho.com/display/EAI/Dimension+Lookup-Update
You don't need to do anything, just fill in the dialog.