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
- 8534 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
How to create or import flat file definition in to the warehouse designer?
What is a grid in Informatica?
How can we create index after completion of load process?
Define joiner transformation?
What is aggregate cache in aggregator transformation?
Under what condition selecting sorted input in aggregator may fail the session?
What is primary and backup node?
What is the advantage of informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How do you load first and last records into target table?
Differentiate between a database and data warehouse?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What does refresh system mean, and what are its distinctive choice?
What are the different types of transformation available in informatica.
What are roles and groups and benefits of using them?
