is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
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 are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do you mean by blocking transformation?
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 ?
Differentiate between a database and data warehouse?
How to implement security measures using repository manager?
What is xml source qualifier transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
How does a sorter cache works?
What are the various types of transformation?
Did u used latest transformations of 8.6.0? for what?
Write the different tools in the workflow manager?
define galaxy repository in informatica
What is session task and command task?
Where do we use mapping variables in informatica?
Explain constraint based loading in informatica