Hi ,
if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs
Funnel different Meta Data
Moderators: chulett, rschirm, roy
Re: Funnel different Meta Data
Hi,
Table1: c1, c2, c3, c4
Table2: c1,c2,c3
Table3: c1,c2
select c1, c2, c3, c4 from Table1
select c1, c2, c3, 'T2C4' as c4 from Table2
select c1, c2, 'T3C3' as c3, 'T3C4' as c4 from Table3
After funnel you can set NULL values/any desired values in those columns using transformer.
Thanks,
Waseem
Table1: c1, c2, c3, c4
Table2: c1,c2,c3
Table3: c1,c2
select c1, c2, c3, c4 from Table1
select c1, c2, c3, 'T2C4' as c4 from Table2
select c1, c2, 'T3C3' as c3, 'T3C4' as c4 from Table3
After funnel you can set NULL values/any desired values in those columns using transformer.
Thanks,
Waseem
Syed
---------
Wait and Watch
---------
Wait and Watch
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Note that the Funnel stage requires identical metadata on all inputs, hence the constants in syeed's response. But why not perform a UNION ALL in the SELECT statement?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.