is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create multiple integration service on single repository?

705


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1612


What is union transformation in informatica?

701


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


Can u generate reports in Informatica?

661






Mention few power centre client applications with their basic purpose?

540


What is the difference between a connected look up and unconnected lookup?

578


What are the various types of transformation?

646


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


What are the reusable transformations?

704


What is an active transformation?

648


What is the difference between writing a joiner query in ANSI style and THETA style?

1925


What are the tuning techniques you applied during your last project

1567


How can we handle two sessions in informatica?

616


4 yrs etl devloper roles and responsibilities?any body give solutions

1585