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?
Is anyone able to help out with this request?
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,
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