DSXchange

i want to know when the datastage run 1 record/second , and what's the reason ? database: oracle datastage:6.0.1 It means that, for whatever reason, you are processing approximately 60 rows per minute. There are myriad possible causes, including very large rows. See earlier comments for some ideas.

When you reset the job in Director do you get extra diagnostic information in an event "from previous run..."? I suspect you are running out of memory, and thereby generating an access violation. It may also be the case that your loading into the database table is generating 50 warnings so you are t...

You have an unusual idea of "main". Usually main controls everything else. So you will need a "super main" to run the five seq jobs then your "main".

Stop Job from Director client. Wait.

And how do you determine whether that key value already exists in the target or not (without some kind of lookup, that is)?

You don't use DataStage.

Constraints are DataStage's way of directing data flows.

To do it purely in source requires a HarryPotter stage.

saurabhgupta4u wrote: where can i get this Server??

You buy it from IBM or an authorized reseller. You need lots and lots of money.

Why?

SCD involves some kind of comparison with target, even if it's only to check for existence.

You simply can't do it with source alone.

Are you confusing SCD (slowly changing dimension) with CDD (changed data detection)?

Stop Job in Director is the best.
Cleanup Resources in Director is next best.
There is also the DS.TOOLS menu on the server.

My earlier reply on this thread contains a complete answer.

You are wrong. You need a -param option for each parameter.

1) dsadm is a user ID, not a command 2) a binary for invoking either a DataStage or a UniVerse environment 3) never kill jobs through UNIX commands - use the proper utilities 4) -param option with dsjob 5) whatever you design For more information search the forum. Good luck with your interview.

Yes and no. You can include EVAL or any valid SQL expression in the derivation in the Columns grid. Otherwise no.

You have not yet read the next record.

Therefore you can not compare anything to it.

What you ask is impossible.

Is that sufficiently definitive?

chandra wrote:Hi ,

I want to pass the parameter to job from unix .
how can i acchive this.

Please be more specific. The usual method is to interrogate the job parameter value using the dsjob command line interface, once job execution has completed.