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

how can we extract data with out having any common column

Answer Posted / vijay

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the main features of datastage?

1088


What are some different alternative commands associated with "dsjob"?

1079


what are the errors,warnings in datastage

2618


in oracle target stage when we use load option and when we use upsert option?

2201


What are the primary usages of datastage tool?

1016


table actions available in oracle connector?

1554


What are the types of containers?

1140


What are the components of datastage?

1062


What are the difference types of stages?

1132


Describe stream connector?

1245


Differentiate between datastage and datastage tx?

1003


Define ds designer?

1214


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2042


What is active and passive stage?

1360


How to perform incremental load in datastage?

1124