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
What is the use of an aggregator cache file?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is song in infrmatica...?
What is difference between a gateway node and worker node?
Difference between Target-based loading and constraint-based loading?
What do you mean by enterprise data warehousing?
What are the databases that informatica can connect to windows?
list out all the transformations which use cache?
What is the command used to run a batch?
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
How do you load first and last records into target table?
Why update strategy and union transformations are active? Explain with examples.
What is the format of informatica objects in a repository?