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


is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?

Answers were Sorted based on User's Feedback



is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / mike

If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.

Is This Answer Correct ?    10 Yes 5 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / usha

we want join in SQ we should have primary key and foreign
key relation ship ...


but, in joiner we dont need primary key and foreign key
relation ship

Is This Answer Correct ?    0 Yes 0 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / bharu_295

if u want to join the tables we need to have primary and foreign key relationship other wise if we join we get Cartesian product of the data.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is the exact meaning of domain?

3 Answers  


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


How many input parameters can exist in an unconnected lookup?

0 Answers  


what are challenges that you faced in testing? give solution to it?

1 Answers  


What are the performance considerations when working with aggregator transformation?

0 Answers  


diffrence between command task and control task

1 Answers   iNautix,


What is power play plug in?

2 Answers  


What are data-driven sessions?

0 Answers  


What do you understand by SOA of Informatica?

0 Answers  


What happens if we dont select data driven option?

2 Answers   Zensar,


What is the scenario which compels informatica server to reject files?

0 Answers  


how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  


Categories