is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
- 3 Answers
- 7315 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
What is data caches/ index caches?
Mention a few design and development best practices for informatica?
What is the command used to run a batch?
What is aggregate cache in aggregator transformation?
Is it possible to use a client with different version than that of its Informatica server?
What's the layout of parameter file (what does a parameter file contain?)?
What is intricate mapping?
What all join we can perform in LOOKUP transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a transaction control transformation?
Write the prerequisite tasks to achieve the session partition?
how we can load rejected record's at run time?(not through bad files)
What are ETL Tools?
How you can differentiate between connected lookup and unconnected lookup?
