too many SP transformations

[ProDev]

Have you guys ever used more Stored Procedure transformations inside Informatica mapping ?

In my case, I have 12 stored procedures transformations used inside mapping. Off couse, these mappings are taking one input and retruning 1 output after a lot data processing being done at each SPs.

What I feel is, the performacne in this situation, is too bad. B'cuz, if I execute all these SPs at SQL*PLUS prompt, those are too fast.

Any ideas ...

 

[blom0344]

What exactly are you doing within those stored procedures?

Can you give some examples and include the code for us to look at?

T. Blom
Information analyst
tbl@shimano-eu.com