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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the Default Source Option For Update Strategy Transformation?

1240


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199


What is a difference between complete, stop and abort?

1083


Sequence generator, when you move from develoment to production how will you reset

2039


What is main use of mapplet?

1132


Clarify the utilization of aggregator cache record?

1001


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058


wf dont have integration severances how you can run?

1938


What are the new features of informatica 9.x at the developer level?

1043


What is domain in terms of informatica?

1007


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554


What is domain and gateway node?

1165


What is an aggregator transformation?

1096


Explain incremental aggregation in informatica

1130


Why do you use Mapping Parameter and mapping variable?

1763