DSXchange

Is that a quiz question?
The answer is FUTILITY (notice the answer in caps)

Also a little bit info on your design would help too.

There is also a Stored Procedure Stage in versionis 7.5.1 and higher which can execute stored procedures. It can also be invoked in the before/after sql tab of OCI stage.

Is'nt that query going to make all read only jobs as !readonly

Here at dsxchange.
They are mostly UV commands. So if you can get your hands on any UV manual. That should be ok. But dont just start executing whatever command. Be careful.

QA testing is usually to analyze the data being processed. For jobs, usually the ETL lead or architect who has prior solid development experience can analyze the jobs. When i check jobs i look for points like ease of maintenance, check to see if there is a performance bottleneck and prefer modulariz...

They are user defined environment variables that 'your friend' must be using within the IPC stage. See where they are defined, read about those properties in IPC stage pdf present in the help books.

chulett wrote:What is your target, a sequential file? Your output field really needs to be a character field of some sort to retain the leading zeroes, hence my question.

need answer to that question from you sshetter!

What will happen for years 2000 and 2004? They require 366 iterations rather than 365.

karmadasai wrote:I would like to keep information about a ORAOCI Stage , I need the SQL string defined by the user.

I missed out on that part.

But that doesnt explain why this job runs in development. It also runs well in production for two days before it starts aborting and we need to re compile it. Then we get a two run ticket !! We are not too sure. If you define a variable and through manipulation it gets populated the routine will be...

Great. Now put @FALSE in the constraint of the output link inside the transformer. Then tell us what is the select rows/sec ?

Are you sure your looking at the correct sequential file/ data set?

Well Craig built a job like yours and it works on his end. I tried something like this a while back, i had no problems. So you will have to contact support one way or the other. In the mean time try to get everything done in the script itself. THAT's your workaround. There is only so much we can do....

Thats ok. You are a new poster and we extend a warm welcome. I thought it was my duty to guide you from the very begining.