Sunday, April 14, 2013

Funnel stage

1)The Funnel stage is a processing stage that combines multiple inputs into a single output. It can have any number of inputs and a single output link. 

2)The metadata for all input data sets must be identical.

3)Funnel can be operated in three Modes and default Mode is Continuous

a)Continuous: 

1)Combines the records of the input link in no guaranteed order. 

2)It takes one record from each input link in turn.  If data is not available on an input link, the stage skips to the next link rather than waiting. 

b)Sort Funnel:
Combines the input records in the order defined by the value(s) of one or more key columns and the order of the output records is determined by these sorting keys. 

c)Sequence:  Copies all records from the first input link to the output link, then all the records from the second input link and so on.

No comments:

Post a Comment