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
- 8801 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 |
why we need informatica
What is meant by pre and post session shell command?
What is batch and describe about types of batches?
HOW TO GET THE LATEST DATA IN SCD ?
What is up date strategy and what are the options for update strategy?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
is it possible to index the data in cache of lkp transformation ?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
how can we check whether a particular cache is static or dynamic?
Differentiate between mapping parameter and mapping variable?
what is mapping parameter and mapping variables
 Informatica Checkpoints
Teradata 
