Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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...srinu.thadi

Answer Posted / krish

regarding this problem we can capture da common data only
which column are identical in all inputs.funnel receives
only common meta data fields from inputs & leaves un manched
meta data fields
ex;
let we have one field like a in t1 & field a's data like
1
2
3
4
then we have two field like a,b in t1 & fields a,b's data like
1 2
2,3
2,5
3,6

funnel data gives the out put only identical fields data like
1
2
3
4
1
2
2
3

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why fact table is in normal form?

1251


Explain datastage architecture?

1402


Which algorithm you used for your hashfile?

1182


How to RD using transformer?

1424


What is the purpose of pivot stage?

1168


What is the purpose of interprocessor stage in server jobs?

2233


What is "fatal error/rdbms code 3996" error?

1267


What are the different kinds of views available in a datastage director?

1030


How a source file is populated?

1066


What is quality stage?

988


What are the types of containers and how to create them?

980


What is data partitioning?

1204


why do u need the IOS upgradation in a FC switch

2283


What are the enhancements made in datastage 7.5 compare with 7.0?

1148


Define oconv () and iconv () functions in datastage?

1416