Hi,
I have requirement here. I need to run a SQL query on a table to find whether the desired values are present. If yes, then I need to execute a stored procedure.
Can I achieve it in the following way?
I have a job containing three stages, a source Oracle/ODBC stage, a transformer and a target Oracle stage.
In the first stage, I need to execute a query on a table. In the transformer stage, I need to take the output of source stage to see whether I have the desired values. If these values are present, I need to go to the target stage. My target stage needs to execute a stored procedure (The stored procedure definition is impoted before-hand).
Is this scenario possible? Else, please provide me with other options.
Cheers,
Mohan
Executing target stage based on the source stage input
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 66
- Joined: Tue Dec 07, 2004 12:48 pm