DSXchange

Take two stage variable S1 and S2.. Initialise both to zero.

Use below logic.

SAL+S1 => S2 ( Map S2 to cumu_column)
S2 => S1

And make sure you execute transformer in sequential mode.

Hi Craig Thanks for the reply. As per my requirement I dont know the upto which the loop has to be run as this is to be calculated run time by the query (select (days(last_day(CURRENT_DATE)) - days(to_date('20120101','YYYYMMDD'))) from SYSIBM.SYSDUMMY1). Aslo we need to pass the same to the main job...

Ray, Thank you so much for helping me on this. My solution is working.

Hi,

Thanks for the reply.So,How can I populate the records to Oracle Table?

Please help me regarding to solve the above issue.

Thanks in Advance,
Sreeni

Hi,
I have parallel jobs having parameter set, Is it possible to run the job from command line by passing paramters at run time?

Thank you Kondeti. It's working.

Hi Ray, I am getting the same error in variable setting can you please help me to solve this. cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/Ascential/DataStage/Projects/rdm/RT_BP42.O/V0S9_Chaining_logic_Join_Transform_Data.C -o C:/Ascential/DataStage/Pr...

Mark a key column which is unique..

thanks.

Thanks Eric, this is helpful for my requirement

If a unix script is called from an execute command activity, is there any way to not display the password in the director log? My script is sh /data/basel2dev/integration/scripts/displaysysdate.sh #Integration.$PrmDBIntgUser# "File Validation Script" "E004" "Unmatched file c...

By execute I mean render, See what I am trying to achieve here is to I want to format the output text which I am sending in the email body for eg if mail cotains alert notification need to show in bold or red color right now my mail text is containing HTML tags which i want to render which displayin...

Using Email notification activity can we send a HTML tags so I can get a mail as an HTML template. Currently I wrote an HTML code in Email notification activity but when I get a mail I can see all my tags and source code it has not been executed

Can you please suggest me the way how to do it.

Thanks a lot everyone for replies we resolved it through looping logic in sequence as mention above !!

Thanks Kirtikumar will try and let you know

ray.wurlod wrote:So you are seeking the complete list of transitions for any input value, through to the endpoint of that list. Does that sound correct?

yes thats the requirement!