I want to get an output as how many records has populated fr

4friends · Post by **4friends** » Mon Dec 10, 2007 5:31 am

Hi All,

I want to get an output as how many records has populated from source to target in a file??????

Thanks in advance

Maveric · Post by **Maveric** » Mon Dec 10, 2007 5:45 am

Search for "DSGetLinkInfo"

ray.wurlod · Post by **ray.wurlod** » Mon Dec 10, 2007 12:56 pm

Create another link in your job using a Copy stage. Add a Column Generator to generate 1 for every row. Add an Aggregator to total these 1's. Write the result to your file.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Dec 12, 2007 5:27 am

Hey ! you can use
dsjob -lstages PRJCT_NAME Jobname
This will give all the stages in that particular job.
Now use the following comman:
dsjob -stageinfo PRJCT_NAME Jobname Src_stage_name > some.txt

From these grep for In Rows and you will get the source row count.
Same thing for the target.

dsjob -stageinfo PRJCT_NAME Jobname Tgt_stage_name >> some.txt