Page 1 of 1
Need to impliment
Posted: Wed Mar 09, 2011 6:23 am
by nareshketepalli
Table A
10
20
30
Table B
40
50
60
Like this and i want out put like
Table1
10
20
30
Table 2
40
50
60
Table 3
10
20
30
40
50
60
In a single job.How is it possible ,any suggestions
Ragards,
Naresh
Posted: Wed Mar 09, 2011 3:20 pm
by ray.wurlod
Funnel stage.
Posted: Thu Mar 10, 2011 11:28 pm
by nareshketepalli
ray.wurlod wrote:Funnel stage. ...
Posted: Thu Mar 10, 2011 11:39 pm
by Ravi.K
Please refer documentation and find same in the below.
The Funnel stage is a processing stage. It copies multiple input data sets to a single output data set. This operation is useful for combining separate data sets into a single large data set. The stage can have any number of input links and a single output link.
Posted: Thu Mar 10, 2011 11:45 pm
by ray.wurlod
Funnel DOES support two input links. I use it frequently. Please justify your assertion to the contrary.
Re: Need to impliment
Posted: Fri Mar 11, 2011 12:48 am
by smart2786
Please follow below design
TableA--->copy--2links---> 1.Table A output
2.Table A output goes to Funnel
TableB--->copy--2links---> 1.Table B output
2.Table B output goes to Funnel
Now the output from funnel contains both table A,Table B Data
This is achievable in single job
Note:Funnel accepts many inputs links with similar metedata but gives only one output.
Re: Need to impliment
Posted: Fri Mar 11, 2011 4:05 am
by nareshketepalli
smart2786 wrote:Please follow below design
TableA--->copy--2links---> 1.Table A output
2.Table A output goes to Funnel
TableB--->copy--2links---> 1.Table B output
2.Table B output goes to Funnel
Now the output from funnel contains both table A,Table B Data
This is achievable in single job
Note:Funnel accepts many inputs links with similar metedata but gives only one output.
Thanks alot