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
changming
Participant
Posts: 68 Joined: Wed Oct 13, 2004 3:35 am
Post
by changming » Thu Jun 04, 2009 12:18 am
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 » Thu Jun 04, 2009 12:46 am
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
Post
by changming » Thu Jun 04, 2009 12:57 am
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 » Thu Jun 04, 2009 1:15 am
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 » Thu Jun 04, 2009 1:26 am
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.
arvind_ds
Participant
Posts: 428 Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali
Post
by arvind_ds » Thu Jun 04, 2009 2:01 am
Also check the output column mapping of the copy stage.
Arvind