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 do you understand by term role-playing dimension?
Informatica settings are available in which file?
How to load last n records of file into target table - informatica
What are different types of transformations available in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to create or import flat file definition in to the warehouse designer?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is informatica powercenter repository?
wf dont have integration severances how you can run?
What is the meaning of up gradation of repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the data movement modes in informatica?
How do you take back up of repository?
How can we delete duplicate rows from flat files?
define galaxy repository in informatica