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 join the tables if they don't have primary and
foreign key relationship and no matching port?

Answer Posted / ramz

use Cartesian product or cross join
select required columns from tab1,tab2;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you migrate data from one environment to another?

1096


State the differences between sql override and lookup override?

1210


How do you load only null records into target? Explain through mapping flow.

2029


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2748


What is joiner transformation?

1010


Define enterprise data warehousing?

1208


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5679


What is a shortcut and copy in Informatica and how two are different with each other?

1199


Can we change Dynamic to Static or Persistent cache? If so what happens?

2213


Explain sessions. Explain how batches are used to combine executions?

1034


What is intricate mapping?

1210


what is SDLC way of code development?

2044


what is the difference between informatica6.1 and infomatica7.1

2280


Which are the different editions of informatica powercenter that are available?

1034


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710