Why we use stored procedure transformation?

Answer Posted / anilchandu

Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.

The main advantage of stored procedure t/r is the code
reusability.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

570


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1842


Can we create a Integration service without a Repository service and vice versa?

720


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1699


What are the new features of informatica 9.x at the developer level?

600






What are the modules in Power Center

1221


How to do unit testing in informatica?

714


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1926


Differentiate between a repository server and a powerhouse?

571


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4304


How does a sorter cache works?

563


waht type of interface is used for testing the data in informatica

1828


What are the uses of etl tools?

641


What is dimensional table?

617


What is a code page?

704