4 Scenarios where we would use stored procedure transformation in Informatica-Obia

• To perform calculation: There will be many well tested calculations which we implement using expression.Instead of using expression we can use stored procedure to store these calculations and then use them by using connected or unconnected stored procedure transformation
• Dropping and recreating indexes: Whenever we have huge number  of record to be loaded to target its better to drop the existing indexes and recreate it.For dropping and recreation of indexes we can make use of stored procedures
• Check the status of a target database before loading data into it.
• To check the space left in Database