copy stage has different input row number and output row num

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
changming
Participant
Posts: 68
Joined: Wed Oct 13, 2004 3:35 am

copy stage has different input row number and output row num

Post by changming »

I have ODBC stage -----------> copy stage-----------> filter stage
the copy stage is simple, just to rename a field, but I found the input records number is more than output record name. Any idea why this happened?
I also change the copy stage option face=true, than I got same problem. then I change copy stage again not to rename field, I still got less number in output from I can see from link information.
any one have ever solved similar problem can help me?
vrishabhsagar
Participant
Posts: 33
Joined: Mon Nov 12, 2007 1:02 am
Location: Bangalore

Post by vrishabhsagar »

Do you get any warnings in the director? Something related to records getting dropped?
Rishabh Sagar V
Bangalore
changming
Participant
Posts: 68
Joined: Wed Oct 13, 2004 3:35 am

no warning.

Post by changming »

vrishabhsagar wrote:Do you get any warnings in the director? Something related to records getting dropped?
No warning. Job run successfully
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you please capture the report of link row counts for the Copy stage and post it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
changming
Participant
Posts: 68
Joined: Wed Oct 13, 2004 3:35 am

Post by changming »

ray.wurlod wrote:Can you please capture the report of link row counts for the Copy stage and post it? ...
Sorry, Ray. I don't know how to capture the report. :(
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

How did you find out the difference or discrepency?
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Also check the output column mapping of the copy stage.
Arvind
Post Reply