DSXchange

Responses have already been provided to tell you what could have happened. But, if you could tell us if your job is just performing transformations or if it is loading a database, it would be easier. Or is it one of those which sources, transforms and loads all in the same job? Now, that would need ...

The question you put across is 'whenever one of the job fails'. You may want to be more specific. For example, what if the job did not fail, but had warnings. Also, how would you want the other jobs handled if one of them failed, should the entire sequence be aborted or only the job that failed shou...

Use an Aggregator stage with the Derivation COUNT on your key field. Yes, aggregation and sort are expensive. But, I don't understand how using the system variables @INROWNUM or @OUTROWNUM did not give you the desired result. Or is it that I have not understood your problem?

gateleys

Design your sequence to check this hash file and skip the ones that are already finished and run the once that are not finished!!! Hi vcannadevula, I think your design is interesting. Can you provide a more details about designing sequence to check against the hashed file and skip finished ones? Al...

For example, if the incoming value appears in ASCII format as "eH", we'd like to translate this into 0110010101001000 and map each of the bits into a separate target column in our outputs. Peter The ASCII uses 8-bits to represent a character (7 actually). So, build a translation table whi...

chulett wrote:Simple - checkpoints. Look on the General tab of any Sequence job for the following options:

* Add checkpoints so sequence is restartable on failure
* Automatically handle activities that fail

This feature is NOT available in DS7.0.

gateleys

Anyone!!!

It could be due to any complex transform rules in your job, or any stage that requires some time to compute. Hence, in the beginning, work is two-fold, in computation, and in writing data to the output link. But once computation portion get less, most of the work in pushing data out, thereby increas...

Have you tried the system variable @OUTROWNUM?

gateleys

Thanks Craig. Woah!! needed a lot of explanation. And to think it was just there. But I prefer the log sent by the NotificatioActivity, in terms of rows processed by each stage and time.

Thanks again. I hope the orginal poster got his answer as well.

gateleys

It does provide the report on each link. how many rows inserted,updated and rejected, depending on the stage. Hey Jules, I tried it with a job with a sequential file source passed to a transformer with one output link to ORAOCI9, and another to a reject file. The job had over 800,000 records. But, ...

I know that the job log provides the row count information, and that EtlStats provides that and more. However, my question came up because of Ray's statement : Open status view in Director, select your category. Use Filter to restrict by status if required. Choose Print from the Project menu. If nee...

chulett wrote:

gateleys wrote:Hey Jules...

Sorry, Jules has been dead for almost 100 years now.

Grrr!!! Its been a habit..looking at that part of the post for the poster's signature. Anyways, Craig (yeah! its correct), do you have an answer to my previous post?

gateleys

Hi all, As a curiosity:idea: , I want to know what are the limitations on datastage i.e what we cannot do using datastage? Any answers and suggestions are appreciated. Thanks, Sean. Now, I am curious. :roll: Or, was this question asked with an intent to compare DataStage with other ETL tools; like ...

It does provide the report on each link. how many rows inserted,updated and rejected, depending on the stage. Hey Jules, I tried it with a job with a sequential file source passed to a transformer with one output link to ORAOCI9, and another to a reject file. The job had over 800,000 records. But, ...