I have created a server job to fetch records from two different source Oracle connectors and in the next step I am joining those records using Transformer stage.
When I execute the source Select SQL queries on their DBs, they result with 1 record each but when I run the server job, they are fetching zero records. Is there anything I need to change for fetching data in server jobs?
Oracle Connector resulting zero records
Moderators: chulett, rschirm, roy
Best to start by posting in the Server forum. I've moved you there. Also known as 'here'.
Secondly, no. What's different about the SQL in the job versus the tool - parameters? Look at the detail in the job's log to see what was actually executed.
Secondly, no. What's different about the SQL in the job versus the tool - parameters? Look at the detail in the job's log to see what was actually executed.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
No, there's nothing special you need to do. DataStage is a client just like your Developer tool - both send the SQL to the database and it sends back the results. If you are certain the SQL is the same then perhaps they are not connecting to the same instance. Been there, done that, got the t-shirt.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers