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 / rajesh.dwh

To do this in server job: use merge stage/transformer stage
to join these two tables (Ta and Tb) mapping them and load
it into target (sequential/ODBC/ORACLE) etc.

To do this in parallel job: use merge/joiner stage and do
above task.

thanks & regards:
todbarajesh@gmail.com

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you filter data in hashed file?

3721


What are the main differences you have observed between 7.x and 8.x version of datastage?

1023


How do you register plug-ins?

920


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

992


EXPLAIN SCD

1338


What are the stages in datastage?

1027


Explain how a source file is populated?

1312


how to export or import the jobs in .ISX file

1132


Define data aggregation?

1046


How a server job can be converted to a parallel job?

1042


Explain ibm infosphere information server and highlight its main features?

1034


What are the different options associated with dsjob command?

1370


How rejected rows are managed in datastage?

1444


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

1094


What are the important features of datastage?

1048