Need to impliment

[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

[ray.wurlod]

Funnel stage.

[nareshketepalli]

Funnel stage. ...

[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.

[ray.wurlod]

Funnel DOES support two input links. I use it frequently. Please justify your assertion to the contrary.

[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.

[nareshketepalli]

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