Transforms in workbench

user007663
user007663 Member
in Archive

Hello Admin,

 

Can you please let me know what is the difference between transforms in the workbench and the one being applied at the tranformation level in the dataflow?

 

Thanks,

Bharti

Comments

  • laura_igl
    laura_igl Member

    Hi,

    Is anyone able to help out with this request?


    Thanks

  • rahul93
    rahul93 Contributor

    Hi, 

    Transforms in the workbench only have limited (of which some you may not be able to do in a dataflow) features like formatting a date field, encrypting the data for some users etc. 

    Whereas transformations in a dataflow can manipulate the data like in sql which can include changing the format of date, making some calculations and creating new fields, selecting a subset of the dataset etc.

     

    hope this helps,

  • rado98
    rado98 Contributor

    The other key differences I see worth noting are:

     

    Workbench requires your PC to do he crunching

    Workbench does not have a 10000 duplicates limit when doing lookups / joins

    Workbench is quite clunky in general 

     

This discussion has been closed.

Categories