DSXchange

chulett,

I am running the job using a Unix script and the following command is being used:

dsjob -server $SVR -user $USR -password $PSWD -run $parm1 -warn 0 -wait -jobstatus $dsproj $dsjobnm

Thanks

Yes Chulett, i have set it for unlimited warnings..Still its getting reset by itself.

Thanks

Sue

Thanks Chulet..So, Whenever a warning message is ignored, the job gets reset instead of finished(seelog)??

Please clarify.

Thanks

Sue

I am looking to ignore the warning messages only if i have unique key violatio message. Is it possible to check that and ignore those warning messages using dsjob command?

Thanks

Sue

Hi,

We are running a job using dsjob command and set the warning limit to 50.
The job is being reset after the completion.
I was expecting to see Finshed(Seelog) after the jobname instead of HasBeenReset.

The number of warnings did not exceed 50.

Please advise.

Thanks

Sue

Hi, I started designing the job as follows: Source --> Transform --> Sort (Based on date)--> Transform(12 Stage variables)-->Target Basically i would need to calculate total for that particular month and the year period before calculating the average in the stage variables. Please guide me with the ...

Ray,

Sorry for the confusion. For each month, average should be calculated based on the number of months as divisor.

Here is the example:
Input

Month Price
1 40
2 20
3 30

Output(:

Month Rolling Average
1 40
2 30(40+20/2)
3 30(40+20+30/3)


Thanks
Sue

Ray, Here is my requirement: Suppose in table A we have two fields Contract_No and Cont_Price,I need the following information: Contract_No :Rolling average for a month Cont Price :Rolling Average for a month Contract_No : Rolling Average for 12 months Cont_Price:Rolling Average for 12 months exampl...

Ray,

How can i distinguish between the years?
Suppose for 2008, i should calculate only for those months in that year and for 2009 i should not calculate from the previous year i.e.2008.

Is it possible to give me an idea on the design flow?

Thanks

Sue

Sai,

Thanks for your response.

Since i am using server edition, i would like to go for the second option.

I believe that we need to use sort and aggregator transforms before calculating the values in the stage variables. Please correct me if i am not getting it correctly.

Thanks again

Sue

Any help would be really appreciated..

Thanks in advance

Sue

What if i need to caluclate rolling averages for months and year in the same query??Please advise..
Also, i would like to use DS stages and functions to perform this..

Thanks

Sue

Ray,

Thank you. Don't we need an aggregator stage after the sort stage?
Can you explain the logic used in stage variables?Sorry if i am asking simple questions..




Regards,

Sue

Ray,

Thanks for your reply. We are using Server edition of datastage.

Could you please assist me with the design flow if possible?

Thanks

Sue

It is coming from DB.

Any ideas?

Sue