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 / madhusudhan

If you want combine 3tables with different column name.
First use modify stage between source and funnel stage.
change the cloumns name in the 3tables into standard format.

or

you can try with transformer for creating new column name
for each table.

mailme if you have queries.
samala.madhu@gmail.com

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between datastage and informatica?

1062


Differentiate between odbc and drs stage?

997


What is datastage?

1031


Lookup constraints

1202


What are the differences between datastage and informatica?

1112


How do you schedule or monitoring the job?

1135


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4140


Differentiate between data file and descriptor file?

989


what is the difference between == and eq in UNIX shell scripting?

1422


What could be a data source system?

941


Name the different sorting methods in datastage.

991


Differentiate between validated and Compiled in the Datastage?

1196


What is the flow of loading data into fact & dimensional tables?

1014


What are the various kinds of containers available in datastage?

976


Why we use surrogate key?

1159