In Informatica, stored procedures can be called within transformation expressions using the :SP.Identifier(arguments) syntax. This allows the integration service to execute the procedure and capture return values or output parameters directly within the mapping logic.