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

table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?

Answer Posted / arshad basha

hi... if the meta data are same in both tables we can go for funnel stage.If atleast one column is same in both tables we can go for merge and join stage and ofcourse can use look up.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1250


Differentiate between Join, Merge and Lookup stage?

1078


What are datastage sequences?

1109


What are stage variables?

1193


What is datastage?

1071


What is use Array size in datastage

1768


Explain how a source file is populated?

1353


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

789


How you Implemented SCD Type 1 & Type 2 in your project?

4117


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5106


How do you import and export data into datastage?

1223


To see hidden files in LINIX?

1513


Demonstrate experience in maintaining quality process standards?

2528


What are the types of hashed files in data stage

1098


What are the functionalities of link partitioner and link collector?

996