if u want to join the tables we need to have primary and foreign key relati

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

Question Posted / bharu_295

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

Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

1140

What is the use of target designer?

1117

what is diff b/t sorter t/r and agg have the option sorter property...

2230

What is main use of mapplet?

1176

What is lookup transformation?

1093

What is meant by a domain?

1189

Where is metadata stored?

1192

Explain the difference between a data warehouse and a data mart?

1111

Can you generate sequence numbers without using the sequence generator transformation?

1162

What is an Integration service in Informatica?

1191

Can anyone tell me the new features in Informatica 9 Version?

2207

What are the prerequisite tasks to achieve the session partition?

1295

what is size of u r database?

2365

Clarify the aggregator change?

1080

write a query to retrieve the latest records from the table sorted by version(scd)

1114