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
r u done any partitions in ur project?
What is a dimensional model?
What is rank transformation?
What are ETL Tools?
What is rank transformation in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
server hot-ws270 is connect to Repository B. What does it mean?
What could be the possible resons of locks by user?
What is complex mapping?
Describe expression transformation?
What are multi-group transformations?
What is deployment group?
What is the function of union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Mention few power centre client applications with their basic purpose?