DSXchange

kumar_s

I havnt checked Current and previous SCODE but only SCODE <> 09. Can you please provide your values inputs on how to achieve the last two records scenario? thanks As long as the current SCODE = 09, the value for CNT_TOTAL will be 0. Which will be acheived by the stage variable condition 'CNT_TOTAL ...

kumar_s

Pls post the full log. What are all the stages used?
There should be a warning message before/after this fatal error.
The player process responsible for the update action in the given node got teminated due the error which is not provided.

kumar_s

Its a typical Pivot. As mentioned Pivot Stage should be enough to accomplish this if the number of occurance is constant. Plugin for Pivot stage should be available i CD if not installed initially.
If the occurance is not constant the sencond approach would be apropriate.

kumar_s

I havnt checked Current and previous SCODE but only SCODE <> 09.

kumar_s

If you dont mind adding another routine after the job, you can make use of LinkInfo to calculate the number of records passed in each link and append to the each file. If you want to accomplish in a same job, you need to process all the data into the aggregator to find the max of it. This may likely...

kumar_s

The change you made in dsdlockd config is to avoid deadlocks. It may be use ful if you often get 'Cannot get Exclusive access ....', but apart from this, is there any other changes recomended from Ascential?

kumar_s

Alternativly you can process the desired outcome in a job or routine and pass it as UserStatus to the Job Activity.

kumar_s

You can reject using filter or transformer based on given two different condition into two files. And you can raise the error or waring based on the number of records passed to the link. This can also be post processed. You can make use of DSLogWarn or DSLogInfo to give useful inforamtions.

kumar_s

Is it oracle 10g.
Are you trying to access or drop a table which is already droped.
What you get if you issue

Code: Select all

select * from user_recyclebin

from command prompt?

kumar_s

Use stage variable method.

Code: Select all

MNO_CUR = Inlink.MNO
PNO_CUR = Inlink.PNO
SCODE_CUR = Inlink.SCODE
CNT = Inlink.CNT 
CNT_TOTAL = If (MNO_CUR = MNO_PRV And PNO_CUR = PNO_PRV And SCODE_CUR <> 09) CNT_TOTAL + Inlink.CNT Else 0
MNO_PRV = MNO_CUR
PNO_PRV = PNO_CUR

kumar_s

What is changed exactly?
Is the name of the table changed?
Are you sure there is not other stages using that particular table name. Even annotation used to point out the usase will be reflected in dsx.
The other way to find the stages usage analysis would be
http://www.dsxchange.com/viewtopic.php? ... highlight=

kumar_s

If number of iteration is know, the job can be made as multiple instance and individual parameters with different values can be passed.

kumar_s

Still its an undefiened issue.

http://www.dsxchange.com/viewtopic.php? ... +outputrec

http://www.dsxchange.com/viewtopic.php? ... +outputrec

But many alternate methonds has been identified for the same reason.

http://www.dsxchange.com/viewtopic.php? ... +outputrec

kumar_s

Do a Search.

kumar_s

It cannot be read as Date data type.
Date requires %yyyy. Rather you can read as Char field and convert it into date in any consicutive transformer.

Search found 5168 matches