Page 1 of 1
how to find row count of a link and store it is as a data
Posted: Fri Jul 20, 2007 11:33 pm
by s_porkalai
Hi all,
i have to find the row count of no of rows coming from the source and no of rows rejected and no of rows inserted into target.
is there any option for finding row count in parallel extender 7.5 version.
can anyone help me regarding this
thanks in advance
Re: how to find row count of a link and store it is as a dat
Posted: Sat Jul 21, 2007 4:26 am
by vikasjawa
Hi,
Apart from the visual check, you cen get this stat from the log files in the DS Director.You need to set the enviornment variable:APT_DUMP_SCORE
to "true" for this.
Posted: Sat Jul 21, 2007 4:47 am
by Minhajuddin
If you have links coming from the source, going to the Target DB and a reject link. Then you can find the number of rows processed on those links by a simple routine. Search the forum for DSLinkInfo and you'll get a lot of ways to do it.
Posted: Sat Jul 21, 2007 7:04 am
by chulett
DSGetLinkInfo actually.
Posted: Sat Jul 21, 2007 5:34 pm
by ray.wurlod
There is an environment variable (something like APT_PM_ROWCOUNTS) that causes each player process to display its row counts.
Posted: Mon Jul 30, 2007 10:06 pm
by s_porkalai
Is there any way of using DSLinkInfo to capture the row count in After job routine
Posted: Mon Jul 30, 2007 10:23 pm
by ArndW
s_porkelai - whyever not?
Posted: Tue Jul 31, 2007 12:10 am
by ray.wurlod
s_porkalai wrote:Is there any way of using DSLinkInfo to capture the row count in After job routine
DSGetLinkInfo()