how to find row count of a link and store it is as a data

s_porkalai · Post by **s_porkalai** » Fri Jul 20, 2007 11:33 pm

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

vikasjawa · Post by **vikasjawa** » Sat Jul 21, 2007 4:26 am

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.

Minhajuddin · Post by **Minhajuddin** » Sat Jul 21, 2007 4:47 am

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.

chulett · Post by **chulett** » Sat Jul 21, 2007 7:04 am

DSGetLinkInfo actually.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 21, 2007 5:34 pm

There is an environment variable (something like APT_PM_ROWCOUNTS) that causes each player process to display its row counts.

s_porkalai · Post by **s_porkalai** » Mon Jul 30, 2007 10:06 pm

Is there any way of using DSLinkInfo to capture the row count in After job routine

ArndW · Post by **ArndW** » Mon Jul 30, 2007 10:23 pm

s_porkelai - whyever not?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 31, 2007 12:10 am

s_porkalai wrote:Is there any way of using DSLinkInfo to capture the row count in After job routine

DSGetLinkInfo()

DSXchange

how to find row count of a link and store it is as a data

how to find row count of a link and store it is as a data

Re: how to find row count of a link and store it is as a dat