Funnel warnings

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
tatikramos
Participant
Posts: 36
Joined: Tue Sep 16, 2008 12:15 pm

Funnel warnings

Post by tatikramos »

Hello There,
i have this parallel job in datastage V8. and i am using a funel stage but for some reason i am getting a lot of warnings saying:
Funnel_47: When checking operator: Dropping "message4" in transfer from "inRec3" to "outRec".
you guys know why is this?
thanks for you help :)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What do you mean by "a lot"? One per column, or one per row processed? In the former case it's metadata related, in the latter case it's data related. Please verify that the row structure is identical on all inputs and on the output link of the Funnel stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
tatikramos
Participant
Posts: 36
Joined: Tue Sep 16, 2008 12:15 pm

Post by tatikramos »

one per column.
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Post by betterthanever »

[quote="tatikramos"]one per column.[/quote]

check the metadata for all the inputs to the FUNNEL stage.
they should have same number of colums/column names and metadata as well.
datastage_slk
Participant
Posts: 4
Joined: Mon Jan 26, 2009 5:50 pm

Post by datastage_slk »

betterthanever wrote:
tatikramos wrote:one per column.
check the metadata for all the inputs to the FUNNEL stage.
they should have same number of colums/column names and metadata as well.
Before the funnel stage you might be concatenating some fields and if the input fields of a stage are not used on the output link then these warnings arise.

I got same warnings. Is there a way which can remove these?
Beginner
tatikramos
Participant
Posts: 36
Joined: Tue Sep 16, 2008 12:15 pm

Post by tatikramos »

You are correct, i am concatenating some fields. i have to input link (invoiceid,line(i concatenate some fields here)) i pass this to the funel i join them using the invoicelineid and i outpu only the line. so you think funel doesnt like the concatenate part or just because i am not outputing all the columns from the input links?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The latter.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It is a requirement of the Funnel stage that the record schema on the inputs and output links are all identical. At least structurally.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply