Performance In mapping

[ssnathbabu]

Hi

I am using 10 +10 mappings to load data to target.First 10 from source file to stage table.. and next 10 from stage to target table.

If i reduce the latter 10 mallings to one generic mapping,is there be any injcraese in performance.Because in workflow we are using the same number of sessions as before.after chanign number of mappings also.... Need any ones guidance...Please

let me know if transofrmations reduces will the performance increase or in which way

Thanks in advance

SBabu

 

[blom0344]

This is a very 'open' question.
Will reducing the number of mappings increase overall performance? Perhaps, you lose a certain amount of overhead (initialization,reading from source just once etc)
Normally a transformation (as in expression) will never be the bottleneck.
Typical bottlenecks are:

1. slow extraction from sources
2. aggregations
3. complex filter transformations
4. large join operations

However if your mappings are VERY similar it will probably pay off to try and get everything into 1 mapping.
It all comes down to the nature and the amount of data you need to proces..


Ties Blom