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 Default Source Option For Update Strategy Transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a difference between complete, stop and abort?
Sequence generator, when you move from develoment to production how will you reset
What is main use of mapplet?
Clarify the utilization of aggregator cache record?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
wf dont have integration severances how you can run?
What are the new features of informatica 9.x at the developer level?
What is domain in terms of informatica?
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
What is domain and gateway node?
What is an aggregator transformation?
Explain incremental aggregation in informatica
Why do you use Mapping Parameter and mapping variable?