rss
SOATUBE
Oracle
Custom Search SOABYTE here

Friday, June 25, 2010

Use of assign or XSL transformation

















In certain cases you might be confused whether to use an assign activity or a transform activity. You can use the following thumb rules:
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

 
Blogger Profile