Funnel stage loosing columns

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
devsonali
Premium Member
Premium Member
Posts: 155
Joined: Sun Mar 18, 2007 2:31 pm

Funnel stage loosing columns

Post by devsonali »

Hello All,
I am seeing an issue in my job , I am trying to funnel a set of columns (making sure that metadata matches ) into a funnel stage,all the column show up in input tab but the output tab (that shoes the mapping ) misses a few columns .

I tried to delete the funnel stage and add a new funnel but the problem still persists

Can anybody assist me with recommendations ?
dvpawankumar
Participant
Posts: 46
Joined: Fri Oct 06, 2006 6:36 am
Location: Tucson

Post by dvpawankumar »

Hi,

I am not sure whether the issue is resolved or not..? But want to just give a hin over here. When you are using the funnel stage, make sure that all the inputs are have same number of columns with same names and datatypes. Please check all the input links.

Thanks and Regards,
Pavan.
Thanks and Regards,
Pavan.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Look at the Mapping tab on the output links. Or specify Auto-Map Columns on the stage (t without opening 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

... and the resolution was???
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply