a) If there are only a few number of mappings with no looping, use assign activity.
b) If there are huge number of mappings, and especially if there are loopings to be done, then use XSL transformation.
The logic here is, transformation loads the XSL file for every run. This becomes an overhead if there are only few mappings, which can be easily achieved through the assign activity.
Note: If the source and target schemas are same, and if it is one to one mapping, then you can use assign activity to map the roots of source and target schemas.
0 comments:
Post a Comment