sudha

• Aug 11th, 2006

 

hi

 usage of stored procedure has the following advantages

1checks the status of the target database

2drops and recreates indexes

3determines if enough space exists in the database

4performs aspecilized calculation

Srinivas Kumar

• Aug 22nd, 2006

 

Stored procedure in Informatica will be useful to impose complex business rules.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

to execute database procedures

lingesh

• Oct 11th, 2006

 

Hi ,

 Using of stored procedures plays important role.Suppose ur using oracle database where ur doing some ETL changes you may use informatica .In this every row of the table pass  should pass through informatica and it should undergo specified ETL changes mentioned in transformations. If use stored procedure i..e..oracle pl/sql package this will run on oracle database(which is the databse where we need to do changes) and it will be faster comapring to informatica because it is runing on the oracle databse.Some things which we cant do using tools we can do using packages.Some jobs make take hours to run ........in order to save time and database usage we can go for stored procedures.