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 use of an aggregator cache file?

695


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


Name at least 5 different types of transformations used in mapping design and state the use of each.?

676


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742


what is song in infrmatica...?

1685






What is difference between a gateway node and worker node?

630


Difference between Target-based loading and constraint-based loading?

558


What do you mean by enterprise data warehousing?

652


What are the databases that informatica can connect to windows?

587


list out all the transformations which use cache?

693


What is the command used to run a batch?

578


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4318


How do you load first and last records into target table?

672


Why update strategy and union transformations are active? Explain with examples.

716


What is the format of informatica objects in a repository?

603