is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?
Answers were Sorted based on User's Feedback
Answer / mike
If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / 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 |
Answer / 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 |
Define Incremental Aggregation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the use of an aggregator cache file?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Different qualification between a related rotate toward the sky and isolates look upward?
can you use flat file for repository?why?
What are the uses of a Parameter file?
How informatica process data means how informatica works?
What is active and passive transformation?
How You Pull the records on daily basis into your ETL Server.
How you count the number of records available at your source?
How the dimensions will be loaded?