Why we use stored procedure transformation?

For populating and maintaining data bases.

  • Interview Candidate
  • 9
  • 4415

Showing Answers 1 - 9 of 9 Answers

sithusithu

  • Jan 19th, 2006
 

A Stored Procedure transformation is an important tool for populating and maintaining databases. Database administrators create stored procedures to automate time-consuming tasks that are too complicated for standard SQL statements.

Cheers,

Sithu

  Was this answer useful?  Yes

Shivat

  • Sep 13th, 2006
 

You might use stored procedures to do the following tasks:

  • Check the status of a target database before loading data into it.
  • Determine if enough space exists in a database.
  • Perform a specialized calculation.
  • Drop and recreate indexes.

Shivaji Thaneru

  Was this answer useful?  Yes

Shivat

  • Sep 13th, 2006
 

You might use stored procedures to do the following tasks:

  • Check the status of a target database before loading data into it.
  • Determine if enough space exists in a database.
  • Perform a specialized calculation.
  • Drop and recreate indexes.

Shivaji Thaneru

  Was this answer useful?  Yes

bneha15

  • Apr 18th, 2007
 

we use a stored procedure transformation to execute a stored procedure which in turn might do the above things in a database and more.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions