Interested to Buy Any Domain ? << Click Here >> for more details...
is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
- 3 Answers
- 8669 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Explain sessions. Explain how batches are used to combine executions?
Can you generate sequence numbers without using the sequence generator transformation?
What does update strategy mean, and what are the different option of it?
What are the tuning techniques you applied during your last project
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
what is session parameters?
How you load distinct records into one target and duplicate records into another target?
What is repository manager?
Explain target update override in informatica
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
What is Datadriven?
Howmany ways yoU can update a relational source defintion and what are they?
Teradata 
