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

u can generate surrogate key generator for both the tables
and u can use Inner join based on key column i.e surrogate
key and u can get 10 columns..

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

4129


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

980


Distinguish between informatica & datastage. Which one would you choose and why?

1010


What are the different layers in the information server architecture?

1126


What are the types of hashed files in data stage

1108


What is the difference between datastage and informatica?

1118


What is a quality stage in datastage tool?

1078


Can we use target hash file as a lookup ?

3327


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2447


If you want to use the same piece of code in different jobs, how will you achieve it?

1158


Differentiate between datastage and datastage tx?

1051


Demonstrate experience in maintaining quality process standards?

2554


Define project in datastage?

1094


What is the difference between operational data stage (ods) and data warehouse?

1243


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1552