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
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 |
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 |
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 |
what is the exact meaning of domain?
After we make a folder shared can it be reversed?Why?
How many input parameters can exist in an unconnected lookup?
what are challenges that you faced in testing? give solution to it?
What are the performance considerations when working with aggregator transformation?
diffrence between command task and control task
What is power play plug in?
What are data-driven sessions?
What do you understand by SOA of Informatica?
What happens if we dont select data driven option?
What is the scenario which compels informatica server to reject files?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy