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

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3432


What are the benefits of datastage?

1206


what is use of SDR function?

5144


Notification Activity

1367


what is the use of surogate key in datastage

2276


What are sequencers?

1077


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

1042


What is the difference between the local container and shared container?

1057


project Steps,hits, Project level HArd things,Solved methods?

2083


Differentiate between datastage and informatica?

1157


how do u catch bad rows from OCI stage? And what CLI stands for?

2762


What is a folder? Difference types of stages?

1126


How one source columns or rows to be loaded in to two different tables?

1091


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1848


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

975